Skip to content
Excel

TRUNC function in Excel

Truncates a number to an integer

=TRUNC(number, [num_digits])

TRUNC syntax and parameters

Two arguments, one required.

  • numbernumberRequired

    The number you want to truncate.

  • num_digitsnumberOptional

    A number specifying the precision of the truncation. The default value for num_digits is 0 (zero).

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 Google Sheets

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 Excel gets this done.