IS Functions

Excel function tutorials

If you want to learn Excel, keep reading or Get 10 days of free unlimited access to Lynda.com. for professional help and Excel Tutorials
***************

One of the functions that I’ve used several times on this blog is the “IsError” function where I will test to see if a specific cell has an “error”. Why? For example if I use the vlookup function and I cannot find the “value”, then I’d prefer seeing some other message rather than a #Value

There are many other types of “IsFunctions” that will either return “True” or “False” which can be very useful. Here are a few:

ISBLANK(value)
ISERR(value)
ISERROR(value)
ISLOGICAL(value)
ISNA(value)
ISNONTEXT(value)
ISNUMBER(value)
ISREF(value)
ISTEXT(value)

For example, if I have a database of hundreds of lines and want to be sure that a specific field is not blank, this would be a good way to do it. For example:

Then, I could transform that data into a number by doing the following:

=IF(ISBLANK(B2),1,0)

As you can see, these type of functions are great to add control tests

***************************************************

Look Good at Work and Become Indispensable Become an Excel Pro and Impress Your Boss


***************************************************

One Feedback on "IS Functions"

Phil

I don’t see the point of using the Isblank formula how you have used it. You will still need to search for a 1 to find blank. It is easier to put a filter on col B and select blanks



Comments

Please Leave a Comment!





Please note: Comments may be moderated. It may take a while for them to show on the page.