# Documentation/Calc Functions/TRUNC

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## 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:

- 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 [math]\displaystyle{ \frac{1}{10}\text{th} }[/math]; if**Count**is equal to 2 then numbers are rounded (toward zero) to the next multiple of [math]\displaystyle{ \frac{1}{100}\text{th} }[/math]; 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.

The following conditions (including errors) may be encountered:

- 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.

- Make sure that the number of displayed decimal places is not affected by the setting of the

## Examples:

Formula | Description | Returns |
---|---|---|

=TRUNC(2.348; 2) | Here the function rounds 2.348 toward 0, to 2 decimal places. | 2.34 |

=TRUNC(D1; D2) where cells D1 and D2 contain the numbers -32.4834 and 3.2 respectively. | The value of the Count argument is truncated to 3. Here the function rounds -32.4834 toward 0, to 3 decimal places. |
−32.483 |

=TRUNC(2.648; 0) | Here the function rounds 2.648 toward 0, to the next integer. The alternative formula `=TRUNC(2.648)` returns the same value. |
2 |

=TRUNC(−45.67) | Here the function rounds -45.67 toward 0, to the next integer. | −45 |

=TRUNC(987.65; -2) | Here the function rounds 987.65 toward 0, to the next hundred. | 900 |

## Related LibreOffice functions:

## ODF standard:

## Related (or similar) Excel functions:

TRUNC