Excel’s IS functions return “True” or “False” depending upon the contents of a cell. =ISBLANK( A1) will return “TRUE” if cell A1 is blank and “FALSE” if it is not. Excel offers the following IS functions: ISBLANK, ISERR, ISERROR, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISREF, and ISTEXT.
When you wish to check your information and get an easy True or False outcome, the IS functions in Excel are simply what you require. You can look for blank cells, mistakes, text, numbers, recommendations, and quicker and quickly.
There are presently 9 IS functions, likewise called details functions, in Excel. This consists of ISBLANK, ISERROR, ISTEXT, and more.
When you utilize these functions in combination with others, like the IF function, you can put specifications around your true/false declarations. You can likewise utilize the IS functions on their own if it’s advantageous. Let’s have a look at how they work.
The IS Functions in Excel
The syntax for each function’s formula is the very same with simply one argument: ISLBLANK( worth), ISERR( worth), ISERROR( worth), and so on. The worth can be a cell recommendation, text, or number, and the outcome is either True or False.
Here are the 9 IS functions and quick descriptions of every one.
- ISBLANK: Returns True for a blank cell or False for a cell with material.
- ISERR: Returns True for any mistake worth other than #N/ A or False for the #N/ A mistake.
- ISERROR: Returns True for any mistake worth or False for no mistake.
- ISLOGICAL: Returns True for a sensible worth or False if not a rational worth.
- ISNA: Returns True for the #N/ A mistake or False if not an #N/ A mistake.
- ISNONTEXT: Returns True for a worth that’s not text (or a blank cell) or False for a worth that’s text.
- ISNUMBER: Returns True for a worth that’s a number or False if it’s not a number.
- ISREF: Returns True if the worth is a referral or False if it’s not a recommendation.
- ISTEXT: Returns True if the worth is text or False if it’s not text.
IS Function Examples
As you evaluate the above list, you can see where a few of the IS functions can be found in helpful. At the very same time, you might see a couple that you’ll most likely hardly ever usage. Let’s look at typical usages for a few of the functions.
RELATED: 13 Microsoft Excel Date and Time Functions You Should Know
ISBLANK
The ISBLANK function is one you can utilize to find empty cells where you anticipate information. You can utilize this with the IF function to show a specific worth for blank and non-blank cells.
Here, we have ISBLANK to figure out if cell A1 is blank.
= ISBLANK( A1)
The outcome holds true for a blank cell. You can copy the exact same formula to examine extra cells utilizing the fill manage. As you see below, we have True for blanks and False for non-blanks.
Now we’ll consist of the IF function to show an enigma (?) for a blank cell and a hyphen (-) for a cell consisting of information.
= IF( ISBLANK( A1),"?","-")
As you can see, we now have the outcome of an enigma rather of True for blank cells.
ISERROR
The ISERROR function is perfect if you wish to find mistakes in your sheet for continuously altering information. It works well with the IF function in the very same method that IFERROR deals with its own.
As an example, we’ll utilize ISERROR to figure out if a computation leads to a mistake. We’ll divide the worth in cell A1 by that in cell B1.
= ISERROR( A1/B1)
As you can see, we have a mistake due to the fact that the outcome shows True. The mistake would be #DIV/ 0! due to the fact that you can not divide by absolutely no.
Now we can include the IF function to show something aside from True or False. If the estimation leads to a mistake, we’ll show 1, otherwise, we’ll show 2.
= IF( ISERROR( A1/B1), A, B)
As you can see, our outcome is 1 due to the fact that the estimation returns a mistake.
Again, you can utilize the more recent IFERROR function rather of the IF and ISERROR mix. You can likewise utilize IF and ISERROR with other functions like VLOOKUP to show specific outcomes for both mistakes and non-errors, whereas IFERROR shows just the worth for the mistake.
For more on this particular subject, have a look at our guide on utilizing the IFERROR function to conceal mistakes in your sheet.
RELATED: How to Hide Error Values and Indicators in Microsoft Excel
ISNUMBER and ISTEXT
Next, we’ll take a look at examples utilizing the ISNUMBER and ISTEXT functions. These likewise show True if the worth is a number or text, respectively.
Here, we wish to guarantee we have a number in our cell.