Description
The Excel INT function rounds down any referred fractional number to an integer (in our example given in the image above 32.95 is rounded down to 32).
Instead of following the general principle of rounding numbers, like ROUND and MROUND, this function rounds down to the nearest integer.
The INT function is very helpful where you want your results in integers instead of fractional numbers, however, it has a limitation that it rounds down to the nearest integer.
For example, as given in the image above INT function rounded down 32.95 to 32. Whereas the general principle of rounding numbers requires this number shall have been rounded to 33.
Therefore in the situations where you want to round a fractional number to an integer while keep following the general principle of rounding numbers, it is advised to use the Excel ROUND function with a given zero number of digits as an argument.
=INT(number)
The INT function’s syntax has the following argument:
- number Required.
This argument shall be the number (even stored as text) or reference to the number you want to round. In the example given in the image above the number “32.95” and the cell B3 (i.e. reference to the number) is our required argument.
