# EXCEL FUNCTIONS-ISBLANK

## 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.

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.

## 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