This is an excerpt from Pierre Leclerc (www.excel-vba.com)

Excel functions and formulas

 

The 2 Most Important

Excel Functions AND
Formulas

 

SUMPRODUCT

AND

INDEX/MATCH

 

 

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

 

 

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

 

 

 

 

left arrow Back home