INT

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 to ROUNDDOWN with places set to 0 . INT rounds down using value, whereas ROUNDDOWN rounds down using absolute value, which causes differences for negative values of value .

• 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 to FLOOR with significance 1 for positive values of value and  CEILING with significance -1 for negative values of value .

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.

Examples

Click to open document