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 be rounded down to the nearest integer.
Notes
-
INT
is not equivalent to ROUNDDOWN with places set to 0.INT
rounds down using value, whereasROUNDDOWN
rounds down using absolute value, which causes differences for negative values ofvalue
. -
INT
is also not equivalent to FLOOR with significance -1 for negative values of value 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.