Excel Information Functions

Special

Excel Functions

2003

Special

Excel Functions

2007

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.

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

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