What is the Use of Excel INT Function?
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 for INT Function
number Number you want to round down to the nearest integer.
- It will round down in both positive or negative numbers.
Examples for INT Function
In above example, I have used this formula to remove decimals from the numbers. You can use this function to streamline your numbers in excel.
Download Sample File
Using Excel INT Function can help you round your number where you want to round them to the nearest integer. learn more about INT from here.