# MICROSOFT EXCEL FUNCTIONS- INFORMATION

### INFORMATION FUNCTIONS

INFORMATION group of functions contains the functions which help us to get the information about the status of cell.

This group contains a list of functions needed to get the information about the data contained in the excel sheet cell such as CELL, ISBLANK, ISEVEN, ISODD and many more.

These functions are very important when we need to make a decision in our formulas.

Here is the list of functions which fall under this category. Click the function for its further details i.e. formula syntax, examples, purpose etc.

### INFORMATION FUNCTIONS

#### EXCEL FUNCTIONS-SHEETS

INTRODUCTION SHEETS function comes under the INFORMATION category in Excel. THE SHEETS function simply returns the NUMBER OF SHEETS in …

#### EXCEL FUNCTIONS-SHEET

Table of Contents INTRODUCTION PURPOSE OF SHEET FUNCTION IN EXCEL PREREQUISITES TO LEARN SHEET FUNCTION SYNTAX: SHEET FUNCTION EXAMPLE: SHEET …

#### EXCEL FUNCTIONS-N

INTRODUCTION N FUNCTION comes under the INFORMATION category in Excel. N FUNCTION converts any given value to number. This function …

#### EXCEL FUNCTIONS-ISTEXT

INTRODUCTION When we are creating the expressions for our reports or applications, a special event comes so frequently in our …

#### EXCEL FUNCTIONS-ISREF

INTRODUCTION When we are creating the expressions for our reports or applications, a special event comes so frequently in our …

#### EXCEL FUNCTIONS-ISNUMBER

INTRODUCTION When we are creating the expressions for our reports or applications, a special event comes so frequently in our …

#### EXCEL FUNCTIONS-ISNONTEXT

Table of Contents INTRODUCTION PURPOSE OF IS FUNCTION IN EXCEL PREREQUISITES TO LEARN IS SYNTAX: IS FUNCTION EXAMPLE:IS FUNCTION IN …

#### EXCEL FUNCTIONS-ISNA

Table of Contents INTRODUCTION PURPOSE OF IS FUNCTION IN EXCEL PREREQUISITES TO LEARN IS SYNTAX: IS FUNCTION EXAMPLE:IS FUNCTION IN …

#### EXCEL FUNCTIONS-ISLOGICAL

INTRODUCTION When we are creating the expressions for our reports or applications, a special event comes so frequently in our …

#### EXCEL FUNCTIONS-ISERROR

INTRODUCTION When we are creating the expressions for our reports or applications, a special event comes so frequently in our …

#### EXCEL FUNCTIONS-ISERR

Table of Contents INTRODUCTION PURPOSE OF IS FUNCTION IN EXCEL PREREQUISITES TO LEARN IS SYNTAX: IS FUNCTION EXAMPLE:IS FUNCTION IN …

#### EXCEL FUNCTIONS-ISBLANK

INTRODUCTION When we are creating the expressions for our reports or applications, a special event comes so frequently in our …

#### EXCEL FUNCTIONS-INFO

INTRODUCTION INFO FUNCTION comes under the INFORMATION category in Excel.INFO FUNCTION gives us the option of getting many important information …

#### EXCEL FUNCTIONS-CELL

INTRODUCTION CELL FUNCTION comes under the INFORMATION category in Excel.CELL FUNCTION gives us a lot of information about any cell …