Skip to content
Google Sheets

TRUNC function in Google Sheets

Truncates a number to a certain number of significant digits by omitting less significant digits.

=TRUNC(value, [places])

TRUNC syntax and parameters

Two arguments, one required.

  • valuenumberRequired

    The value to be truncated.

  • placesnumberOptional

    [ OPTIONAL - 0 by default ] - The number of significant digits to the right of the decimal point to retain. If places is greater than the number of significant digits in value, value is returned without modification. places may be negative, in which case the specified number of digits to the left of the decimal place are changed to zero. All digits to the right of the decimal place are discarded. If all digits of value are changed to zero, TRUNC simply returns 0.

TRUNC examples

Formulas you'll actually reuse.

  1. The whole part toward zero — unlike INT, −2.5 becomes −2:

    =TRUNC(B2)

    Result-2

  2. Cut to two decimals without rounding:

    =TRUNC(B2, 2)

    Result23.78

TRUNC in Excel

Same name — your formula ports as-is.

Try TRUNC in the playground

Edit the example — nothing to install.

Preloaded with the TRUNC formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.