Excel INT Function can help us to round down a number to the nearest integer. In simple words, it will give you only integer part of a number by removing decimals from it.

In above example, we have rounded 9.9 to 9 & 8.9 to 8. You can use this rounding formula to remove decimals from your numbers.

Syntax

INT(number)

number Number you want to round down to the nearest integer.

More Information on Excel INT Function

It will round down in both positive or negative numbers.

Example

In the below example, I have used this formula to remove decimals from the numbers. You can use this function to streamline your numbers in excel.

Sample File

What’s Next?

To learn more about Excel INT Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.