Rounds a number down to the nearest integer that is less than or equal to it.
Sample Usage
INT(99.44)
INT(A2)
Syntax
INT(value)
value
- The value to round down to the nearest integer..
Notes
-
INT
is not equivalent toROUNDDOWN
withplaces
set to0
.INT
rounds down using value, whereasROUNDDOWN
rounds down using absolute value, which causes differences for negative values ofvalue
. -
INT
is also not equivalent toFLOOR
with significance-1
for negative values ofvalue
for the same reason as above. It is, however, equivalent toFLOOR
with significance1
for positive values ofvalue
andCEILING
with significance-1
for negative values ofvalue
.
See Also
TRUNC
: Truncates a number to a certain number of significant digits by omitting less significant digits.
ROUNDUP
: Rounds a number to a certain number of decimal places, always rounding up to the next valid increment.
ROUNDDOWN
: The ROUNDDOWN function rounds a number to a certain number of decimal places, always rounding down to the next valid increment.
ROUND
: The ROUND function rounds a number to a certain number of decimal places according to standard rules.
MROUND
: Rounds one number to the nearest integer multiple of another.
FLOOR
: The FLOOR function rounds a number down to the nearest integer multiple of specified significance.
CEILING
: The CEILING function rounds a number up to the nearest integer multiple of specified significance.