|
|
|
|
|
|
||
|
Excel Spreadsheet Information Functions |
||
| Importance | Functions | What it Does |
| Important | CELL | Returns information about the formatting, location, or contents of a cell |
| Important | ISERROR | Returns TRUE if the value is any error value |
|
Rarely Used |
||
| 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 |
ISNUMBER | Returns TRUE if the value is a number |
|
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 |
ISTEXT | Returns TRUE if the value is text |
|
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 |
|
You
like this website on Excel? |