INT

Rounds a number down to the nearest integer.

Sample Usage

INT(5.9)
INT(-5.9)

Syntax

INT(number)

• number - The number which is to be rounded down.
  
  

Examples

INT(5.9) rounds 5.9 down to 5.
INT(-5.9) rounds -5.9 to 6.

Notes

• If number is negative, it is rounded away from 0.
• INT is not equivalent to ROUNDDOWN as 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.
• INT is equivalent to FLOOR with significance 1 for positive values of value and CEILING with significance -1 for negative values of value.