Excel INT vs. TRUNC: How to remove decimal places

In Excel, INT returns the greatest integer less than or equal to the input. By default, TRUNC removes the fractional part. Both return 2 for 2.6, but for -2.6, INT gives -3 and TRUNC gives -2. Use INT when the result must be an integer no greater than the input. Use TRUNC when you want to drop digits toward zero.

What the arguments do

The first argument can be a number, a cell reference, or a calculation. INT has no precision argument. The optional second argument of TRUNC defaults to 0. If your Excel uses different regional settings, adapt the decimal and argument separators in the examples.

Microsoft documentation for INT and TRUNC (INT · TRUNC)

Compare positive and negative values

Enter the values from the first table in A2:A5. Put the formulas in B2 and C2, respectively, and fill down through row 5. Notice that -0.4 becomes -1 with INT and 0 with TRUNC. Both return an existing integer such as -2 unchanged.

=INT(A2)
=TRUNC(A2)
Input INT TRUNC
A2 2.6 2 2
A3 -2.6 -3 -2
A4 -2 -2 -2
A5 -0.4 -1 0

Choose where TRUNC cuts off digits

Enter the inputs in A8:A11 and the digit counts in B8:B11. Enter the formula in C8 and fill down through row 11. A digit count of 2 keeps two decimal places at most, and 0 keeps the integer part. A count of -1 zeroes the units digit, while -2 zeroes the tens and units digits. Even if the first discarded digit is 5 or greater, the preceding digit stays the same.

=TRUNC(A8,B8)
Input Digits Result
A8 9.129 2 9.12
A9 -9.129 0 -9
A10 1234.56 -1 1230
A11 -1234.56 -2 -1200

Cell formatting versus the calculated value

If you format the 2.6 in A2 as a number with zero decimal places, the sheet displays 3 while formulas still read 2.6 from A2. To use the integer 2 in a later calculation, reference the cell containing the conversion formula. Use ROUND when you need the nearest value at a specified precision.