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.

 

Back to the list of mathematical functions