The TRUNC function is another of Excel's rounding functions - except that it does no rounding.
What is does is truncate or chop off the decimal portion of a number leaving only the whole number.
This is very close to the INT function except that INT rounds the remaining whole number down, while TRUNC just leaves the remaining number as is.
To find out more about this non-rounding rounding function, read the short tutorial on the Excel TRUNC Function.
More Rounding Number Functions
Hi Ted, its my first visit here. I really liked this article but I have a question that: will Trunc function also work on negative numbers?
Also, I tried to use this function in Excel VBA but I couldn’t find it there (even under the WorksheetFunction). Is it absent in VBA?