How to use INT Function in Excel

How to use INT Function in Excel2018-11-16T10:27:47+00:00

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.

One Comment

  1. Muhammad Saleem Memon 16 Sep, 16 at 6:56 am - Reply

Leave A Comment