TRUNC Function

About

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

Function Type

Math and trigonometry

Purpose

Truncate a number to the given precision.

Return value

Truncated number

Syntax

=TRUNC(number,[num_digits])

Arguments

number – The number to truncate

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


Example 1


Notes

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