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.