OpenOffice3.org Calc 3. Mathematical Functions
TRUNC(Number,Count) Function
Returns a numeric value. Truncates the
number indicated by the first argument. Displays the result with the number of
decimal digits indicated by the argument “Count”. The argument “Number” contains
a numeric value or a reference to a cell containing a number. Contains the
number to be truncated. The argument “Count” contains an integer greater than or
equal to zero or a reference to a cell containing a numeric value. Indicates the
number of decimal digits that shows the result.
=TRUNC(4,66666;1) Returns 4,6. Shows the result with a decimal digit.
=TRUNC(-6,22222;2) Returns -6,22. The result have two decimal digits.
=TRUNC(3,999;0) Returns 3. Returns the integer part of number.