Calc Guide

Syntax Description
FALSE() Set the logical value to FALSE. The FALSE()
function does not require any arguments.
IF(test; then_value;
otherwise_value)
Specifies a logical test to be performed. Test is
any value or expression that can be TRUE or
FALSE. Then_value (optional) is the value that is
returned if the logical test is TRUE.
Otherwise_value (optional) is the value that is
returned if the logical test is FALSE.
NOT(logical_value)
Reverses the logical value. Logical_value is any
value to be reversed.
OR(logical_value_1;
logical_value_2;
...logical_value_30)
Returns TRUE if at least one argument is TRUE.
Returns the value FALSE if all the arguments have
the logical value FALSE. Logical_value_1;
logical_value_2; ...logical_value_30 are
conditions to be checked. All conditions can be
either TRUE or FALSE. If a range is entered as a
parameter, the function uses the value from the
range that is in the current column or row.
TRUE() Sets the logical value to TRUE. The TRUE()
function does not require any arguments.
Informational functions
These functions provide information (or feedback) regarding the
results of a test for a specific condition, or a test for the type of data or
content a cell contains.
Table 40: Informational functions
Syntax Description
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.
Appendix B Description of Functions 463