INT()
Syntax. INT(number)
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 ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
