Excel TRUNC Function

Related Functions:
ROUND
ROUNDDOWN
ROUNDUP

Function Description

The Excel Trunc function truncates a supplied number to a specified number of decimal places.

The syntax of the function is:

TRUNC( number, [num_digits] )

Where the arguments are as follows:

number - The number that is to be truncated.
[num_digits] -

An optional argument that specifies the number of decimal places to truncate the supplied number to.

If omitted, the [num_digits] argument uses the default value 0.

Note that:

  • A positive [num_digits] value specifies the number of digits to the right of the decimal point;
  • If [num_digits] is 0 (or is omitted), the supplied number is truncated to the nearest integer;
  • A negative [num_digits] value specifies the number of digits to the left of the decimal point.


Trunc Function Examples

The following spreadsheet shows several examples of the Excel Trunc function:

 Formulas:
  A B
1 99.999 =TRUNC( A1, 1 )
2 99.999 =TRUNC( A2, 2 )
3 99.999 =TRUNC( A3 )
4 99.999 =TRUNC( A4, -1 )
5 -99.999 =TRUNC( A5, 2 )
6 -99.999 =TRUNC( A6, -1 )
 Results:
  A B
1 99.999 99.9
2 99.999 99.99
3 99.999 99
4 99.999 90
5 -99.999 -99.99
6 -99.999 -90

The example in cell B3 of the above spreadsheet shows that, when the [num_digits] argument is omitted, it takes the default of 0. I.e. the supplied number is truncated to an integer.

If you require different rounding rules, check out our comparison of Excel Rounding Functions.

For further information on the Excel Trunc Function, see the Microsoft Office website.