How to use the Trunc Function in Excel

0 Flares 0 Flares

The Trunc function in Excel is used to reduce the number of decimal places on a number without rounding.

Excel provides a few different rounding functions such as Round, RoundDown and Ceiling to cater for all your rounding needs. However the beauty of the Trunc function is that you can set the number of decimal points for a number without rounding.

Truncating numbers in this way will affect the number and therefore impact on calculations that rely on this number. Using the Excel formatting tools to reduce the number of decimal places is another alternative that does not affect the number involved.

Using the Trunc Function

The syntax for the Trunc function is;

=TRUNC(number, num_digits)

Number – The value to be truncated.

Num_digits – The number of decimal places to be used. This is optional and if omitted is set to 0 removing all decimal places.

The image below shows an example of the Trunc function being used.

Other Rounding Functions

The Round function

The Ceiling Function

The Floor Function