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.

EXCEL FUNCTIONS-SHEETS

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

EXCEL FUNCTIONS-SHEET

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

EXCEL FUNCTIONS-N

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

EXCEL FUNCTIONS-ISTEXT

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

EXCEL FUNCTIONS-ISREF

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

EXCEL FUNCTIONS-ISNUMBER

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

EXCEL FUNCTIONS-ISNONTEXT

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

EXCEL FUNCTIONS-ISNA

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

EXCEL FUNCTIONS-ISLOGICAL

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

EXCEL FUNCTIONS-ISERROR

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

EXCEL FUNCTIONS-ISERR

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

EXCEL FUNCTIONS-ISBLANK

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

EXCEL FUNCTIONS-INFO

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

EXCEL FUNCTIONS-CELL

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