Excel TRUNC Function

HomeExcel Functions List (Top 100) Examples + Sample FileExcel TRUNC Function (Example + Sample File)

What is EXCEL TRUNC FUNCTION

The Excel TRUNC Function is listed under Microsoft Excel's Maths Functions category. It returns an integer after truncating the original number. In simple words, it removes the decimals from a number to a specific precision and then returns the integer part of the result.

How to use it

To learn how to use the TRUNC function in Excel, you need to understand its syntax and arguments:

Syntax

TRUNC(number, [num_digits])

Arguments

  • number: The number you want to truncate.
  • [num_digits]: A number to specify precision to truncate a number.

Notes

  • If you skip specifying multiple it will return with an error.
  • It rounds away from zero.
  • If you have two multiples on the same distance it will return the multiple which is higher than the number you are rounding.

Example

To master the TRUNC function we need to try it out in an example, so make sure to check out the below one:

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

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.