SpreadCE Help


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)


Information functions

CELL(info_type, reference)
Returns information about a worksheet cell.

info_typeThe 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 text alignment that has been applied to the cell (not currently implemented)
"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

referenceThe cell about which you want information.



COUNTBLANK(range)
Returns the number of blank cells in a range.

rangeThe reference of the cells you want to check.



ERROR.TYPE(error_val)
Returns a number corresponding to the type of the error.

error_valThe 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/A7
other#N/A




INFO(type_text)
Returns information about the current spreadsheet.

type_textThe type of information you want returned. The possible values are:

"directory"The path of the current file
"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.

valueThe cell whose value you want to check.



ISERR(value)
Returns TRUE if the value is an error other than #N/A, otherwise FALSE.

valueThe expression whose result you want to check.



ISERROR(value)
Returns TRUE if the value is an error, otherwise FALSE.

valueThe expression whose result you want to check.



ISEVEN(number)
Returns TRUE if the number is even, otherwise FALSE.

numberThe number you want to check.



ISLOGICAL(value)
Returns TRUE if the value is a logical value, otherwise FALSE.

valueThe expression whose result you want to check.



ISNA(value)
Returns TRUE if the value is the error #N/A, otherwise FALSE.

valueThe expression whose result you want to check.



ISNONTEXT(value)
Returns TRUE if the value is not a string, otherwise FALSE.

valueThe expression whose result you want to check.



ISNUMBER(value)
Returns TRUE if the value is a number, otherwise FALSE.

valueThe expression whose result you want to check.



ISODD(number)
Returns TRUE if the number is odd, otherwise FALSE.

numberThe number you want to check.



ISREF(value)
Returns TRUE if the value is a reference, otherwise FALSE.

valueThe expression whose result you want to check.



ISTEXT(value)
Returns TRUE if the value is a string, otherwise FALSE.

valueThe 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.

valueThe 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.

valueThe value, or cell containing the value, that you want to check.
The returned values are:

number1
text2
logical4
error16
array64