How to Use Excel IS Function (Example + Video)

Excel IS Function (Example + Video)

Excel IS Function

When to use Excel IS Function

IS function can be used when you want check a specific value and get either TRUE or FALSE based on the outcome.

What it Returns

It returns TRUE if the condition is met and FALSE if it is not met.

Syntax

=ISBLANK(value)

=ISERR(value)

=ISERROR(value)

=ISLOGICAL(value)

=ISNA(value)

=ISNONTEXT(value)

=ISNUMBER(value)

=ISREF(value)

=ISTEXT(value)

Input Arguments

  • value – the value that you want to test. It could be a blank (empty cell), error, logical value, text, number, or reference value, or a name referring to any of these. Based on the IS formula you use, it would return either TRUE or FALSE.

Additional Notes

  • While Excel automatically converts a numerical value in double quotes to a number in formulas, this is not applicable in IS formulas.
    • For example, ISNUMBER(“10″) would return a FALSE, as 10 in double quotes is treated as text.

Excel IS Function – Live Example

Excel IS Function – Video Tutorial

Related Excel Functions: