How to use INT Function in Excel

The INT function rounds down a number to the nearest integer.

In simple words, it returns only integer part of a number by removing decimals from it.



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


In the below example, we have rounded 9.9 to 9 and 8.9 to 8. You can use this rounding formula to remove decimals from the numbers.

remove decimals from number using excel int function


  1. It will round down both positive or negative numbers.

2 thoughts

Leave a Comment

Your email address will not be published.