By Sections
Other Links
Appendix E: Excel Spreadsheets Information Functions (17)
This web page is an appendix. For more see Excel Information formulas in lesson 3-11
Here is the list of the functions of the information category. Of the 17 functions of the lookup and reference category 4 are interesting and useful. Follow the links below to discover formulas using them.
| Importance | Functions | What it Does |
| Interesting | CELL | Returns information about the formatting, location, or contents of a cell |
| Essential | ISERROR | Returns TRUE if the value is any error value |
| Interesting | ISNUMBER | Returns TRUE if the value is a number |
| Interesting | ISTEXT | Returns TRUE if the value is text |
|
Rarely Used |
ERROR.TYPE | Returns a number corresponding to an error type |
|
Rarely Used |
INFO | Returns information about the current operating environment |
|
Rarely Used |
ISBLANK | Returns TRUE if the value is BLANK |
|
Rarely Used |
ISERR | Returns TRUE if the value is any error value except #N/A |
|
Rarely Used |
ISEVEN | Returns TRUE if the number is even |
|
Rarely Used |
ISLOGICAL | Returns TRUE if the value is a logical value |
|
Rarely Used |
ISNONTEXT | Returns TRUE if the value is not text |
|
Rarely Used |
ISNA | Returns TRUE if the value is the #N/A error value |
|
Rarely Used |
ISODD | Returns TRUE if the value is odd |
|
Rarely Used |
ISREF | Returns TRUE if the value is a reference |
|
Rarely Used |
N | Returns a value converted to a number |
|
Rarely Used |
NA | Returns the error value #N/A |
|
Rarely Used |
TYPE | Returns a number indicating the data type of a value |