613-749-4695
[email protected]
Excel Spreadsheets Functions: Information
|
|
613-749-4695 |
|
Tips and Ideas on Excel |
Tips and Ideas on Macros |
|
This page is offered to you as reference Click here for more on the interesting Excel spreadsheets functions of information category |
Excel Lesson 24E of 24: Excel Spreadsheets Information Functions (17)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 |
|
Next Chapter: Logical Functions in Excel |
Excel Table of Contents |
|
|
|
|
613-749-4695 |
|
Tips and Ideas on Excel |
Tips and Ideas on Macros |
Excel Spreadsheets Functions: Information
Discover Even More in