Calc Guide

Syntax Description
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.
• As a percentage. To enter an interest rate as a percentage, type in the interest
rate followed by the % key. For example, to compute a loan with a 3.25%
interest rate, enter 3.25% into the function.
If you enter it as 3.25, the function will treat it as a 325% interest rate.
Accounting systems vary in the number of days in a month or a year used in
calculations. The following table gives the integers used for the basis parameter
used in some of the financial analysis functions.
Appendix B Description of Functions 381