Contents
An Introduction to Excel Functions
Financial Functions
Date and Time Functions
Math and Trigonometry Functions
Statistical Functions
Lookup and Reference Functions
Database Functions
Text Functions
Logical Functions
Information Functions
Engineering Functions
Cube Functions
Add-In and Automation Functions
|
 |
 |
 |
|
Information Functions
Function |
Description |
Syntax |
||
CELL |
Returns information about the formatting, location, or contents of a cell |
(info_type,reference) |
||
ERROR.TYPE |
Returns a number corresponding to an error type |
(error_val) |
||
INFO |
Returns information about the current operating environment |
(type_text) |
||
ISBLANK |
Returns TRUE if the value is blank |
(value) |
||
ISERR |
Returns TRUE if the value is any
error value except #N/A |
(value) |
||
ISERROR |
Returns TRUE if the value is any error value |
(value) |
||
ISEVEN |
Returns TRUE if the number is even |
(value) |
||
ISLOGICAL |
Returns TRUE if the value is a
logical value |
(value) |
||
ISNA |
Returns TRUE if the value is the #N/A error value |
(value) |
||
ISNONTEXT |
Returns TRUE if the value is
not text |
(value) |
||
ISNUMBER |
Returns TRUE if the value is
a number |
(value) |
||
ISODD |
Returns TRUE if the number is odd |
(value) |
||
ISREF |
Returns TRUE if the value is
a reference |
(value) |
||
ISTEXT |
Returns TRUE if the value is text |
(value) |
||
N |
Returns a value converted to
a number |
(value) |
||
NA |
Returns the error value #N/A |
( ) |
||
TYPE |
Returns a number indicating the data type of a value |
(value) |
| Acknowledgments & Disclaimer |
Tags
No one has tagged this page yet... Be the first.. Log in using the link below and return to add your tag
