Excel Forum
Similar Content
Guide to Referencing Other Excel Files with Formulas and Functions
Tutorial: Your guide to making cross-workbook formulas and functions. This includes an overview of p...
Show a Single Comment in Excel - Means the Comment is Always Visible, No Hovering Necessary
Macro: This macro in Excel allows you to display or show a particular comment in Excel. This will...
Multiply by True and False in Excel
Tutorial: You can multiply numbers by TRUE and FALSE in Excel. This effectively allows you to elimi...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.