<< Click to Display Table of Contents >> INT (round down to nearest integer) |
Syntax:
INT(Number)
Description:
Rounds Number down to the nearest integer.
Note:
When applying this function to negative numbers, note the difference between this function and other round functions such as ROUNDDOWN:
ROUNDDOWN(-1.234, 0) returns -1, because here the amount of number is rounded down to the next smaller integer.
INT(-1.234) results in -2, since here the negative number itself is rounded down to the next smaller integer.
Example:
INT(5.9) returns 5
INT(-5.1) returns -6
See also:
TRUNC, ROUNDDOWN, ROUNDUP, ROUND, MROUND, FIXED, EVEN, ODD, CEILING, FLOOR