Definition. This function rounds a number down to the next smaller integer.
Argument
number (required) The real number to be rounded down to an integer
Background. Real numbers include decimal numbers and extend the rational numbers with irrational numbers. This is necessary for third-level calculus operations—root extraction, logarithmic calculus, and exponentiation—with absolute rational numbers.
Integers are rational numbers and include all positive and negative numbers and 0. The INT() function truncates the decimal places of positive numbers and rounds negative numbers to the nearest smaller number.
Examples. You prepare your tax return and want the amount owed to be an integer rounded down (in your favor).
More examples for this function are:
=INT(4,3)
returns 4
.
=INT(-2.51)
returns -3
.
=INT(78.8)
returns 78
.