Excel Information Functions

Excel functions, formulas and examples

 

Excel tips on functions and formulas

Excel Functions and Formulas

excel-functions tutorial

Excel macros (VBA)

Excel and VBA Expert

Excel fonctions et formules

Special

Excel Functions

2003

 

sumproduct

index-match

subtotal

iserror

countif

sumif

hlookup

lookup

vlookup

 

 

Special

Excel Functions

2007

 

averageif

averageifs

countifs

sumifs

iferror

 

 

 

 

 

 

 

Lesson 5: Excel Spreadsheets  Information Functions (17)

In annex 5 you have found a description of all 17 Excel functions in the "Informationt" category. Below is the list of the 2 most useful ones. See more on the very powerful IISERROR fonction in lesson 16

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

In the downloadable tutorial on Excel functions and formulas you will find example of formulas using each of these functions and even many of them assembled in easy and powerful formulas.


Excel Functions and Formulas Sitemap


Go to the next lesson:
Lesson 6: Excel Logical Functions


See the complete version of this lesson in
The Tutorial on Excel
Functions

 

 

 

Excel tips on functions and formulas

excel-functions tutorial

Excel macros (VBA)

Excel and VBA Expert

Excel fonctions et formules

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