EXCEL FUNCTIONS-ISNA

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.

FunctionReturns TRUE if
ISBLANKValue refers to an empty cell.
ISERRValue refers to any error value except #N/A.
ISERRORValue refers to any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!).
ISLOGICALValue refers to a logical value.
ISNAValue refers to the #N/A (value not available) error value.
ISNONTEXTValue refers to any item that is not text. (Note that this function returns TRUE if value refers to a blank cell.)
ISNUMBERValue refers to a number.
ISREFValue refers to a reference.
ISTEXTValue refers to text.
ISEVENReturns TRUE if the value is an even number.
ISODDReturns TRUE if the value is an odd number.
ISFORMULAReturns 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 

EXCEL:IS FUNCTION DATA SAMPLE

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

FunctionReturns TRUE if
  
  
FUNCTIONTEST CELLRESULTFUNCTION USED
IF CELL IS BLANK TRUETRUE
IF ERROR IS OTHER THAN #N/AHIFALSEFALSE
IF VALUE IS AN ERROR OR NOT#DIV/0!TRUEFALSE
IF THE NUMBER IS EVEN46TRUETRUE
IF THE CELL CONTAINS A FORMULA57TRUEFALSE
IF THE CELL CONTAINS A LOGICAL VALUETRUETRUEFALSE
IF THE VALUE IS NOT AVAILBLE (#N/A) FALSEFALSE
IF THE VALUE IS NON TEXT4564TRUETRUE
IF THE VALUE IS A NUMBER45TRUEFALSE
IF THE NUMBER IS ODD79TRUEFALSE
IF VALID REFERENCE IS THEREHJTRUETRUE
IF THE NUMBER IS TEXTHELLOTRUEFALSE


EXAMPLE:IS FUNCTION USAGE :ANIMATED STEPS

EXCEL:IS FUNCTION ANIMATED EXAMPLE