PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

CONTENTS

EXCEL FUNCTIONS-IS

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

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
 
GYANKOSH IS FUNCTION EXAMPLE
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

 

 

Function Returns TRUE if
 
FUNCTION TEST CELL RESULT FUNCTION USED
IF CELL IS BLANK TRUE =ISBLANK(G5)
IF ERROR IS OTHER THAN #N/A HI FALSE =ISERR(G6)
IF VALUE IS AN ERROR OR NOT #DIV/0! TRUE =ISERROR(G7)
IF THE NUMBER IS EVEN 46 TRUE =ISEVEN(G8)
IF THE CELL CONTAINS A FORMULA 57 TRUE =ISFORMULA(G9)
IF THE CELL CONTAINS A LOGICAL VALUE TRUE TRUE =ISLOGICAL(G10)
IF THE VALUE IS NOT AVAILBLE (#N/A) FALSE =ISNA(G11)
IF THE VALUE IS NON TEXT 4564 TRUE =ISNONTEXT(G12)
IF THE VALUE IS A NUMBER 45 TRUE =ISNUMBER(G13)
IF THE NUMBER IS ODD 79 TRUE =ISODD(G14)
IF VALID REFERENCE IS THERE HJ TRUE =ISREF(G15)
IF THE NUMBER IS TEXT HELLO TRUE =ISTEXT(G16)
 

EXAMPLE:IS FUNCTION USAGE :ANIMATED STEPS

EXCEL:IS FUNCTION ANIMATED EXAMPLE

OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

gyankosh060309@gmail.com

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: