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