Information functions
[ ] indicates optional parameters
CELL(info_type, [reference])
COUNTBLANK(range)
ERROR.TYPE(error_val)
INFO(type_text)
ISBLANK(value)
ISERR(value)
ISERROR(value)
ISEVEN(number)
ISLOGICAL(value)
ISNA(value)
ISNONTEXT(value)
ISNUMBER(value)
ISODD(number)
ISREF(value)
ISTEXT(value)
N(value)
NA()
TYPE(value)
CELL(info_type, [reference])
Returns information about a worksheet cell.
info_type | The type of information you want returned. The possible values are: |
|
"address" | A string containing the cell reference |
"col" | The column number of the cell |
"color" | 1 if the cell is formatted in color for negative values, otherwise 0 (not currently implemented) |
"contents" | The result of the formula in the cell, or 0 if the cell is empty |
"filename" | The path, filename and sheet name of the cell |
"format" | The number format that has been applied to the cell |
"parentheses" | 1 if the cell is formatted in parentheses for positive values, otherwise 0 (not currently implemented) |
"prefix" | The alignment of text in the cell: |
|
' | left-aligned |
" | right-aligned |
^ | centred |
\ | filled |
|
"protect" | 1 if the cell is locked, otherwise 0 |
"row" | The row number of the cell |
"type" | A string representing the type of the cell result: "b" for blank, "l" for label (string), otherwise "v" |
"width" | The cell width in characters |
|
reference | The cell about which you want information. If this parameter is omitted it defaults to the cell containing the formula. |
COUNTBLANK(range)
Returns the number of blank cells in a range.
range | The reference of the cells you want to check. |
ERROR.TYPE(error_val)
Returns a number corresponding to the type of the error.
error_val | The error value, or cell containing the error value, that you want to check. |
| The returned values are: |
|
#NULL! | 1 |
#DIV/0! | 2 |
#VALUE! | 3 |
#REF! | 4 |
#NAME? | 5 |
#NUM! | 6 |
#N/A | 7 |
other | #N/A |
|
INFO(type_text)
Returns information about the current spreadsheet.
type_text | The type of information you want returned. The possible values are: |
|
"directory" | The path of the current directory |
"memavail" | The number of bytes of memory available |
"memused" | The number of bytes of memory used |
"numfile" | The number of spreadsheet files that are open |
"origin" | A string containing the address of the cell in the top-left corner of the scrollable region |
"osversion" | The operating system version number |
"recalc" | A string containing "Automatic" or "Manual", depending on the recalculation mode |
"release" | The release version with which this program is compatible |
"system" | The operating system type |
"totmem" | The total number of bytes of memory |
|
ISBLANK(value)
Returns TRUE if the value is a reference to an empty cell, otherwise FALSE.
value | The cell whose value you want to check. |
ISERR(value)
Returns TRUE if the value is an error other than #N/A, otherwise FALSE.
value | The expression whose result you want to check. |
ISERROR(value)
Returns TRUE if the value is an error, otherwise FALSE.
value | The expression whose result you want to check. |
ISEVEN(number)
Returns TRUE if the number is even, otherwise FALSE.
number | The number you want to check. |
ISLOGICAL(value)
Returns TRUE if the value is a logical value, otherwise FALSE.
value | The expression whose result you want to check. |
ISNA(value)
Returns TRUE if the value is the error #N/A, otherwise FALSE.
value | The expression whose result you want to check. |
ISNONTEXT(value)
Returns TRUE if the value is not a string, otherwise FALSE.
value | The expression whose result you want to check. |
ISNUMBER(value)
Returns TRUE if the value is a number, otherwise FALSE.
value | The expression whose result you want to check. |
ISODD(number)
Returns TRUE if the number is odd, otherwise FALSE.
number | The number you want to check. |
ISREF(value)
Returns TRUE if the value is a reference, otherwise FALSE.
value | The expression whose result you want to check. |
ISTEXT(value)
Returns TRUE if the value is a string, otherwise FALSE.
value | The expression whose result you want to check. |
N(value)
Returns a number corresponding to the input value, or 0 if the input value is a string. You should not need to use this function, as values are automatically converted where necessary when they are used in formulas.
value | The value you want as a number. |
NA()
Returns the error value #N/A.
TYPE(value)
Returns a number corresponding to the type of the value.
value | The value, or cell containing the value, that you want to check. |
| The returned values are: |
|
number | 1 |
text | 2 |
logical | 4 |
error | 16 |
array | 64 |
|