Calc Guide

Syntax Description
COMBINA(count_1;
count_2)
Returns the number of combinations for a given
number of objects (repetition included). Count_1
is the total number of elements. Count_2 is the
selected count from the elements.
CONVERT(value; "text";
"text")
Converts a currency value of a European
currency into Euros. Value is the amount in the
currency to be converted. Text is the official
abbreviation for the currency in question (for
example, "EUR"). The first Text parameter gives
the source value to be converted; the second
Text parameter gives the destination value. Both
text arguments must be within quotes.
COS(number)
Returns the cosine of the given number (angle
in radians).
COSH(number) Returns the hyperbolic cosine of the given
number (angle in radians).
COT(number)
Returns the cotangent of the given number
(angle in radians).
COTH(number) Returns the hyperbolic cotangent of the given
number (angle in radians).
COUNTBLANK(range)
Returns the number of empty cells. Range is the
cell range in which the empty cells are counted.
COUNTIF(range;
criteria)
Returns the number of elements that meet
certain criteria within a cell range. Range is the
range to which the criteria are to be applied.
Criteria indicates the criteria in the form of a
number, a regular expression, or a character
string by which the cells are counted.
DEGREES(number)
Converts the given number in radians to
degrees.
EVEN(number)
Rounds the given number up to the nearest
even integer.
EXP(number) Returns e raised to the power of the given
number.
FACT(number)
Returns the factorial of the given number.
FLOOR(number;
significance; mode)
Rounds the given number down to the nearest
multiple of significance. Significance is the
value to whose multiple of ten the number is to
be rounded down (.01, .1, 1, 10, etc.). Mode is
an optional value. If it is indicated and non-zero
Appendix B Description of Functions 431