Excel Function : TRUNC

Download now!

Excel Function : TRUNC

Category

Math and trigonometry

Description

Truncates a number to an integer

Microsoft Excel Reference Page

https://support.office.com/en-us/article/TRUNC-function-8b86a64c-3127-43db-ba14-aa5ceb292721

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