Excel IS Function (Example + Video)
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:
