How To Use Excel INT Function

how to use excel ifna function

Quick Intro

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.

Rounding with Excel INT Function

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.

Examples o Understand Excel INT Function

Sample File

download sample file to learn more about this tips

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.

There is also you have MROUND function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.