Excel Guides

Using the TRUNC Worksheet Function in Excel

TRUNC is a worksheet function in Excel that allows you to truncate a number to a certain number of decimal places. It is useful when you want to round a number down to the nearest whole number or to a certain number of decimal places.

To use the TRUNC function, select the cell in which you want the result to appear and enter the following formula:

=TRUNC(number, num_digits)

where number is the number that you want to truncate and num_digits is the number of decimal places that you want to keep. For example, if number is 12.345 and num_digits is 2, the result will be 12.34.

You can also use the TRUNC function to round a number up or down to the nearest multiple of a certain number. To do this, enter a negative value for num_digits. For example, if number is 12.345 and num_digits is -2, the result will be 12.35 (rounded up to the nearest multiple of 2).

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.