This Excel tutorial explains how to use the Excel TRUNC function with syntax and examples.
The Microsoft Excel TRUNC function returns a number truncated to a specified number of digits.
The syntax for the Microsoft Excel TRUNC function is:
TRUNC( number, [digits] )
The TRUNC function can be used in the following versions of Microsoft Excel:
The TRUNC function can be used in Microsoft Excel as the following type of function:
Let's look at some Excel TRUNC function examples and explore how to use the TRUNC function as a worksheet function in Microsoft Excel:
Based on the Excel spreadsheet above, the following TRUNC examples would return:
=TRUNC(A1) Result: 662 =TRUNC(A1, 0) Result: 662 =TRUNC(A1, 1) Result: 662.7 =TRUNC(A2, -1) Result: 50 =TRUNC(67.891) Result: 67 =TRUNC(-23.67, 1) Result: -23.6
(scroll to see more)