TRUNC Function


TRUNC function in Excel can be used to remove the fractional part of a number.

Function Type

Math and trigonometry


Truncate a number to the given precision.

Return value

Truncated number




number – The number to truncate

num_digits – [optional] The precision of truncation. Default value is 0.

Example 1


INT function is similar to TRUNC function as it returns the integer part of a number after rounding it down.

Read about Excel Functions

Excel Functions in Alphabetical Order (Complete list)

Complete List of Excel Functions (Category wise)

New Dynamic Array Functions in Excel

LET Function in Excel

STOCKHISTORY Function in Excel