Error Information Functions

-

  • ERROR.TYPE

    Tests a supplied value and returns an integer relating to the supplied value's error type

  • ISERR

    Tests if an initial supplied value (or expression) returns an error (EXCEPT for the #N/A error) and if so, returns TRUE; Otherwise returns FALSE

  • ISERROR

    Tests if an initial supplied value (or expression) returns an error and if so, returns TRUE; Otherwise returns FALSE

  • ISNA

    Tests if an initial supplied value (or expression) returns the Excel #N/A error and if so, returns TRUE; Otherwise returns FALSE

Excelq.com doing business as a Service of Venttraffic Media Inc. Excel and other words on this site may be trademarks or registered trademarks of Microsoft Corporation. Microsoft Corporation is not connected in any way with this website, and makes no endorsement of the site or its related contents. All rights reserved. Website powered by Venttraffic Media Inc.