How to use TRUNC Function in Excel

How to use TRUNC Function in Excel2018-11-16T11:25:36+00:00

The TRUNC function truncate decimals, that means remove fractional part of a number.

In the simple words, it removes the decimals from a number to a specific precision and then returns the integer part in the result.

Syntax

TRUNC(number, [num_digits])

  1. number Number you want to truncate.
  2. [num_digits] A number to specify precision to truncate a number.

Example

In the below example, we have used this function to truncate data for removing time from the dates.

As you know, dates are serial numbers and time is in decimal in Excel.

examples to understand excel trunc function

Remember

  1. TRUNC is similar to INT in work. The difference is that trunc only remove decimals from a number where INT remove decimals by rounding down the number to the nearest integer.
Content Protection by DMCA.com

Leave A Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.