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 …