Excel Information Functions

Excel functions                     

 

 

Excel tips on functions and formulas

Excel Functions and Formulas

Excel examples

Excel and VBA Expert

Excel fonctions et formules

The Most Important

Excel Functions

sumproduct

index-match

 

 

 

 

 

 

 

 

 

 

 

 

 

Excel Macros and VBA

Annex 5: Excel Spreadsheets  Information Functions (17)

There are 17 functions in the "Information" category.

Functions What it Does
ISERROR Returns TRUE if the value is any error value
CELL  Returns information about the formatting, location, or contents of a cell
ISNUMBER Returns TRUE if the value is a number
ISTEXT Returns TRUE if the value is text
ERROR.TYPE Returns a number corresponding to an error type
INFO Returns information about the current operating environment
ISBLANK  Returns TRUE if the value is BLANK
ISERR Returns TRUE if the value is any error value except #N/A
ISEVEN Returns TRUE if the number is even
ISLOGICAL Returns TRUE if the value is a logical value
ISNONTEXT Returns TRUE if the value is not text
ISNA Returns TRUE if the value is the #N/A error value
ISODD Returns TRUE if the value is odd
ISREF Returns TRUE if the value is a reference
N Returns a value converted to a number
NA  Returns the error value #N/A
TYPE Returns a number indicating the data type of a value

Excel Functions and Formulas Sitemap

 

 

 

Excel tips on functions and formulas

Excel Functions and Formulas

Excel examples

Excel and VBA Expert

Excel fonctions et formules

SUMPRODUCT  ¦  INDEX/MATCH  ¦  SUBTOTAL  ¦  ISERROR  ¦  COUNTIF  ¦  SUMIF  ¦  HLOOKUP  ¦  LOOKUP  ¦  VLOOKUP
AVERAGEIF  ¦  AVERAGEIFS  ¦  COUNTIFS  ¦  SUMIFS  ¦  IFERROR