Function: ISERROR

Function: ISERROR

The ISERROR Excel function is an Information formula that returns TRUE if the target value contains an error value, and FALSE if it does not. As the name suggests, the formula asks the question “Is error?” to its argument, and returns a Boolean result....
Function: ISERR

Function: ISERR

The ISERR Excel function is an Information formula that returns TRUE, if the reference value is an error code (except for #N/A), and FALSE otherwise. As the name suggests, the formula asks the “Is error?” question, and can be especially useful for...
Function: ISNA

Function: ISNA

ISNA Excel function is an Information formula that checks whether the specified value is an #N/A (not applicable) error. The function returns a Boolean value – TRUE if there is an #N/A error, and FALSE if not. In this guide, we’re going to show you how to use...
Function: IFERROR

Function: IFERROR

The IFERROR function evaluates a formula and returns a specified value if the formula generates an error. Otherwise, the function returns the result of the formula. In this guide, we’re going to show you how to use the IFERROR function and also go over some tips and...