# How to Use Excel IS Function (Example + Video)

## 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.

• 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 – Video Tutorial

Related Excel Functions: FREE EXCEL BOOK