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:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

Leave a Comment

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free Excel Tips EBook Sumit Bansal

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster