How To Use Excel INT Function

How To Use Excel INT Function2017-11-21T06:03:10+00:00

The INT function rounds down a number to the nearest integer.

In simple words, it returns only integer part of a number by removing decimals from it.

Syntax

INT(number)

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

Examples

In the below example, we have rounded 9.9 to 9 and 8.9 to 8. You can use this rounding formula to remove decimals from the numbers.

remove decimals from number using excel int function

Remember

  1. It will round down both positive or negative numbers.
>