HomeExcel Functions ► Excel INT Function

Use Excel INT Function To Round To The Nearest Integer

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.

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 for INT Function


number Number you want to round down to the nearest integer.

More Information

  • It will round down in both positive or negative numbers.

Examples for INT Function

Examples o Understand Excel 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

Download Sample File To Learn More About Excel INT Function

More Tips Related With Excel INT Function


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.

Related Function

MRound | Mod | Trunc

Blog | Excel Function