Tutorial on Excel Information Functions

In this tutorial we will learn the list of Excel Information functions and how to effectively utilize the Information functions for the desired purpose of that we require.

ISERROR Function in Excel: ISERROR Function in Excel identifies the Excel Errors, ISERROR Function in Excel returns TRUE if the Excel Error is identified, if not returns FALSE.

ISERR Function in Excel: ISERR Function in Excel identifies the Excel Errors Except #N/A, ISERR Function in Excel returns TRUE if the Excel Error is identified except #N/A , if not returns FALSE.

ISNA Function in Excel: The ISNA function in Excel, tests if an supplied expression or Value returns the Excel #N/A Error, and if so, returns TRUE, If not the function returns FALSE.

ISNUMBER Function in Excel: The ISNUMBER function in Excel, tests if an supplied expression or Value returns the number, and if so, returns TRUE, If not the function returns FALSE.

ISEVEN Function in Excel: ISEVEN Function in Excel tests if a supplied number (or numeric expression) evaluates to an even number, if so then the Function returns TRUE, if not the function returns FALSE.

ISODD Function in Excel: ISODD Function in Excel tests if a supplied number (or numeric expression) evaluates to an odd number, if so then the Function returns TRUE, if not the function returns FALSE.

ISBLANK Function in Excel: ISBLANK Function in Excel tests if a specified cell is blank (empty) and if so, returns TRUE, if not the function returns FALSE.

ISLOGICAL Function in Excel: ISLOGICAL Function in Excel tests if a supplied value or expression returns a logical value(i.e. TRUE or FALSE). If so the ISLOGICAL Function returns TRUE, if not the function returns FALSE.

ISTEXT Function in Excel: ISTEXT Function in Excel tests if a supplied value has text. If so the ISTEXT Function returns TRUE, if not the function returns FALSE.

ISNONTEXT Function in Excel: ISNONTEXT Function in Excel tests if a supplied value has text. If the supplied value has text then ISNONTEXT Function returns FALSE, if not the function returns TRUE.

ISREF Function in Excel: ISREF Function in Excel tests if a supplied value is a reference. If the supplied value is reference then ISREF Function returns TRUE, if not the function returns FALSE.

ISFORMULA Function in Excel: ISFORMULA Function in Excel tests if a supplied cell has formula in it. If the supplied cell has any formula then ISFORMULA Function returns TRUE, if not the function returns FALSE.

 

lets get started with Tutorial on Excel Information Functions

next small Tutorial on Excel Information Functions