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.
- 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.
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.
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.