|
CELL(info_type; reference)
|
Returns information on a cell such as its address, formatting or contents of a cell based on the value of the info_type argument. Info_type specifies the type of information to be returned and comes from a predefined list of arguments. Info_type is not case sensitive, but it must be enclosed within quotes. Reference is the address of the cell to be examined. If reference is a range, the cell reference moves to the top left of the range. If reference is missing, Calc uses the position of the cell in which this formula is located.
|
|
CURRENT()
|
Calculates the current value of a formula at the actual position.
|
|
FORMULA(reference)
|
Displays the formula of a formula cell at any position. The formula will be returned as a string in the Reference position. If no formula cell can be found, or if the presented argument is not a reference, returns the error value #N/A.
|
|
ISBLANK(value)
|
Returns TRUE if the reference to a cell is blank. This function is used to determine if the content of a cell is empty. A cell with a formula inside is not empty. If an error occurs, the function returns a logical or numerical value. Value is the content to be tested.
|
|
ISERR(value)
|
Returns TRUE if the value refers to any error value except #N/A. You can use this function to control error values in certain cells. If an error occurs, the function returns a logical or numerical value. Value is any value or expression in which a test is performed to determine whether an error value not equal to #N/A is present.
|
|
ISERROR(value)
|
The ISERROR tests if the cells contain general error values. ISERROR recognizes the #N/A error value. If an error occurs, the function returns a logical or numerical value. Value is any value where a test is performed to determine whether it is an error value.
|
|
*ISEVEN_ADD(number)
|
Tests for even numbers. Returns TRUE (1) if the number returns a whole number when divided by 2.
|
|
ISFORMULA(reference)
|
Returns TRUE if a cell is a formula cell. If an error occurs, the function returns a logical or numerical value. Reference indicates the reference to a cell in which a test will be performed to determine if it contains a reference.
|
|
ISLOGICAL(value)
|
Returns TRUE if the cell contains a logical number format. The function is used in order to check for both TRUE and FALSE values in certain cells. If an error occurs, the function returns a logical or numerical value. Value is the value to be tested for logical number format.
|
|
ISNA(value)
|
Returns TRUE if a cell contains the #N/A (value not available) error value. If an error occurs, the function returns a logical or numerical value. Value is the value or expression to be tested.
|
|
ISNONTEXT(value)
|
Tests if the cell contents are text or numbers, and returns FALSE if the contents are text. If an error occurs, the function returns a logical or numerical value. Value is any value or expression where a test is performed to determine whether it is a text or numbers or a Boolean value.
|
|
ISNUMBER(value)
|
Returns TRUE if the value refers to a number. If an error occurs, the function returns a logical or numerical value. Value is any expression to be tested to determine whether it is a number or text.
|
|
*ISODD_ADD(number)
|
Returns TRUE (1) if the number does not return a whole number when divided by 2. Number is the number to be tested.
|
|
ISREF(value)
|
Tests if the content of one or several cells is a reference. Verifies the type of references in a cell or a range of cells. If an error occurs, the function returns a logical or numerical value. Value is the value to be tested, to determine whether it is a reference.
|
|
ISTEXT(value)
|
Returns TRUE if the cell contents refer to text. If an error occurs, the function returns a logical or numerical value. Value is a value, number, Boolean value, or error value to be tested.
|
|
N(value)
|
Returns the number 1, if the parameter is TRUE. Returns the parameter, if the parameter is a number. Returns the number 0 for other parameters. If an error occurs, the function returns a logical or numerical value. Value is the parameter to be converted into a number.
|
|
NA()
|
Returns the error value #N/A.
|
|
TYPE(value)
|
Returns the type of value. If an error occurs, the function returns a logical or numerical value. Value is a specific value for which the data type is determined. Value 1 = number, value 2 = text, value 4 = Boolean value, value 8 = formula, value 16 = error value.
|
