Main Profile

At A Glance

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.
Length: 03:19

Contact

Questions about Excel Magic Trick #101: IS Functions

Want more info about Excel Magic Trick #101: IS Functions? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question