Calc Guide

Syntax Description
the range to which the criteria are to be applied.
Criteria is the cell in which the search criterion
is shown, or the search criterion itself.
Sum_range is the range from which values are
summed; if it has not been indicated, the values
found in the Range are summed.
SUMSQ(number_1;
number_2; ...
number_30)
Calculates the sum of the squares of numbers
(totaling up of the squares of the arguments)
Number_1; number_2;... number_30 are up to
30 arguments, the sum of whose squares is to be
calculated.
TAN(number)
Returns the tangent of the given number (angle
in radians).
TANH(number) Returns the hyperbolic tangent of the given
number (angle in radians).
TRUNC(number; count) Truncates a number to an integer by removing
the fractional part of the number according to
the precision specified in Tools > Options >
OpenOffice.org Calc > Calculate. Number is
the number whose decimal places are to be cut
off. Count is the number of decimal places which
are not cut off.
Financial analysis functions
A note about dates
Date values used as parameters for Calc’s financial functions must be
entered in a specific manner. For example, a date (entered in the US
form) must be surrounded by quotes and with periods separating each
value. To represent August 6, 2004, or 8/6/04, you would enter
“08.06.2004”. If you do not enter the date values as required by the
function, you will not get the correct results. Date formats are locale
specific; check the Help for the acceptable formatting.
A note about interest rates
You can enter interest rates in either of two ways:
• As a decimal. To enter an interest rate as a decimal, divide it by
100 before entering it into a function. For example, to compute a
loan with a 3.25% interest rate, enter .0325 into the function.
Appendix B Description of Functions 435