The TRUNC function truncates a supplied number, to a specified number of decimal places.

Syntax

=TRUNC(number,[num_digits])

Arguments

Argument Description
number The number you want to truncate
[num_digits] Optional. The number of digits to which you want to round the number argument. Default is 0 (zero)

  if [num_digits] is omitted or has a value of 0,  number is rounded to the nearest integer
  if [num_digits] is positive, number is rounded the specified number of digits to the right of the decimal point
  if [num_digits] is negative, number is rounded the specified number of digits to the left of the decimal point

Note: TRUNC and INT are similar in that both return integers.

  • TRUNC removes the fractional part of the number.
  • INT rounds numbers down to the nearest integer based on the value of the fractional part of the number.
  • INT and TRUNC are different only when using negative numbers: TRUNC(-4.3) returns -4, but INT(-4.3) returns -5 because -5 is the lower number.

Examples

  A B C
1 Formula Result Notes
2 =TRUNC(6.8) 6 Truncates 6.8 to return the integer part
3 =TRUNC(-6.8) -6 Truncates -6.8 to return the integer part
4 =TRUNC(0.35) 0 Truncates a number between 0 and 1, returns the integer part