Excel Forum



Excel Magic Trick #101: IS Functions


IS Functions. See how to use the following functions:

ISBLANK functionValue refers to an empty cell.
ISERR functionValue refers to any error value except #N/A.
ISERROR functionValue refers to any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!).
ISLOGICAL functionValue refers to a logical value.
ISNA functionValue refers to the #N/A (value not available) error value.
ISNONTEXT functionValue refers to any item that is not text. (Note that this function returns TRUE if value refers to a blank cell.)
ISNUMBER functionValue refers to a number.
ISREF functionValue refers to a reference.
ISTEXT functionValue refers to text.

IF function formula.

EXCEL IS functions. Excel Logical functions. Excel IsFunctions.





Got a Question? Ask it Here in the Forum.