INTRODUCTION
When we are creating the expressions for our reports or applications, a special event comes so frequently in our way when we need to know the type of the value or the status of the cell. This family of functions is very helpful for us in that case.
The article will discuss about the functions and the detailed example about the usage of these functions.
IS FUNCTION comes under the INFORMATION category in Excel.
IS FUNCTION in combination with other suffixes ,performs many function to know about the status of the cell.
The different available functions are
ISBLANK(value)
ISERR(value)
ISERROR(value)
ISLOGICAL(value)
ISNA(value)
ISNONTEXT(value)
ISNUMBER(value)
ISREF(value)
ISTEXT(value)
ISODD(value)
ISEVEN(value)
ISFORMULA(value)
These functions provide us with the information about the content of the cell like if the cell is blank or not, value is even or odd etc. which will be discussed in detail further in the article.
ALL THESE FUNCTION RETURNS THE RESULT AS TRUE OR FALSE. IF THE CONDITION IS CORRECT, TRUE IS RETURNED, IF NOT, FALSE IS RETURNED.
PURPOSE OF IS FUNCTION IN EXCEL
IS FAMILY OF FUNCTIONS RETURNS THE INFORMATION ABOUT THE CONTENT OF THE CELL. IT CHECKS THE VALUES IN THE CELL AND THE RESULT IS RETURNED AS TRUE OR FALSE. THIS RESULT CAN BE USED TO FURTHER DECIDE THE ACTION OF THE CALCULATION.
PREREQUISITES TO LEARN IS
THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.
- Basic understanding of how to use a formula or function.
- Basic understanding of rows and columns in Excel.
- Of course, Excel software.
Helpful links for the prerequisites mentioned above
What Excel does? How to use formula in Excel?
SYNTAX: IS FUNCTION
The Syntax for the function is
=ISXXX(VALUE/REFERENCE)
REFERENCE Cell address on which the function is to be applied.
Function | Returns TRUE if |
---|---|
ISBLANK | Value refers to an empty cell. |
ISERR | Value refers to any error value except #N/A. |
ISERROR | Value refers to any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!). |
ISLOGICAL | Value refers to a logical value. |
ISNA | Value refers to the #N/A (value not available) error value. |
ISNONTEXT | Value refers to any item that is not text. (Note that this function returns TRUE if value refers to a blank cell.) |
ISNUMBER | Value refers to a number. |
ISREF | Value refers to a reference. |
ISTEXT | Value refers to text. |
ISEVEN | Returns TRUE if the value is an even number. |
ISODD | Returns TRUE if the value is an odd number. |
ISFORMULA | Returns TRUE if the content in the cell is a formula |
EXAMPLE:IS FUNCTION IN EXCEL
DATA SAMPLE
Let us try the usage of IS FAMILY FUNCTIONS.Let us try to use all the functions one by one
STEPS TO USE IS FUNCTION [EXAMPLE]
The example is shown in picture above.
The first column shows the description of the function.
Second cell is the TEST CELL, on which the function will be applied.
Result is the output column.
FUNCTION USED is the function used for that output.
The following function were used
Function | Returns TRUE if | ||
FUNCTION | TEST CELL | RESULT | FUNCTION USED |
IF CELL IS BLANK | TRUE | TRUE | |
IF ERROR IS OTHER THAN #N/A | HI | FALSE | FALSE |
IF VALUE IS AN ERROR OR NOT | #DIV/0! | TRUE | FALSE |
IF THE NUMBER IS EVEN | 46 | TRUE | TRUE |
IF THE CELL CONTAINS A FORMULA | 57 | TRUE | FALSE |
IF THE CELL CONTAINS A LOGICAL VALUE | TRUE | TRUE | FALSE |
IF THE VALUE IS NOT AVAILBLE (#N/A) | FALSE | FALSE | |
IF THE VALUE IS NON TEXT | 4564 | TRUE | TRUE |
IF THE VALUE IS A NUMBER | 45 | TRUE | FALSE |
IF THE NUMBER IS ODD | 79 | TRUE | FALSE |
IF VALID REFERENCE IS THERE | HJ | TRUE | TRUE |
IF THE NUMBER IS TEXT | HELLO | TRUE | FALSE |