Get the Integer Part of a Number in Excel

How to get the integer part, the whole number, from a number that has a decimal after it.

This does not round the number, this ONLY returns the integer, the non-decimal part of the number.

We use the TRUNC function for this.

=TRUNC(number)

The number argument is usually a cell reference but it can also be a hard-coded number or another function/formula.

This returns:

Even if I change the number to where it would normally round up, you can see that using the TRUNC function causes NO rounding to happen.

Notes

The TRUNC function is different from the INT and the ROUND functions in that there is NO ROUNDING with the TRUNC function.

Download the attached workbook to work with the above example in Excel.