Documentation/Calc Functions/TRUNC

Function name:
TRUNC

Category:
Mathematical

Summary:
Rounds a number toward zero to the next multiple of a specified power of 10.

Syntax:
TRUNC(Number[; Count])

Returns:
Returns a real value which is the specified number rounded (toward zero) to the required precision.

Arguments:
Number is a real number, or a reference to a cell containing that number, that is to be rounded.

Count is an integer, or a reference to a cell containing that integer, that is used to specify the precision of the rounding. If Count is omitted, a default value of 0 is assumed. The value of Count is utilized as follows:

The following conditions (including errors) may be encountered:
 * If Count is a positive integer, then rounding is to the right of the decimal separator. For example, if Count is equal to 1 then numbers are rounded (toward 0) to the next multiple of $$\frac{1}{10}\text{th}$$; if Count is equal to 2 then numbers are rounded (toward zero) to the next multiple of $$\frac{1}{100}\text{th}$$; and so on.
 * If Count is equal to zero, then rounding is to the next integer toward 0.
 * If Count is a negative integer, then rounding is to the left of the decimal separator. For example, if Count is equal to -1 then numbers are rounded (toward 0) to the next multiple of 10; if Count is equal to -2 then numbers are rounded (toward 0) to the next multiple of 100; and so on. The value returned by TRUNC will always be an integer when Count is negative.
 * If either Number or Count is non-numeric, then TRUNC reports a #VALUE! error.
 * If Count is a non-integer value, then it is rounded to the next integer in the direction of 0.

Additional details:

 * If you obtain unexpected results from TRUNC, check the following:
 * Make sure that the number of displayed decimal places is not affected by the setting of the Limit decimals for general number format option in the General Calculations area of the dialog ( on macOS).
 * Access the Numbers tab on the Format Cells dialog ( or equivalent interaction) to make sure that relevant cells do not have formatting applied that affects the number of displayed decimal places.


 * Calc's ROUNDDOWN and TRUNC perform identical functions.

Related LibreOffice functions:
INT

ROUND

ROUNDDOWN

ROUNDUP

ODF standard:
Section 6.17.8, part 2

Equivalent Excel functions:
TRUNC