Excel Function : TRUNC

Download now!

Excel Function : TRUNC


Math and trigonometry


Truncates a number to an integer

Microsoft Excel Reference Page


Syntax and Description of the TRUNC Excel Function

The syntax for the TRUNC function in Microsoft Excel is: TRUNC( number, [num_digits] ) Number is the number you want to truncate. Num_digits is the number of digits you want to keep to the right of the decimal point. If omitted, num_digits is assumed to be 0.

About TRUNC Excel Function

TRUNC function in excel returns the number truncated to a specified number of decimal places. It takes two arguments, the number and the number of decimal places. For example, =TRUNC(4.7,1) returns 4.7. =TRUNC(4.7) returns 4