|
Featured Tutorial
Featured Macro
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.
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.