<< Click to Display Table of Contents >> INT (round down to nearest integer)

Syntax:

INT(Number)

Description:

This rounds Number down to the nearest integer.

Note:

When applying this function to negative numbers, note the difference between this function and other rounding functions such as ROUNDDOWN:

ROUNDDOWN(-1.234, 0) returns -1, because here the amount of the number is rounded down to the nearest integer.

INT(-1.234) results in -2, since here the negative number itself is rounded down to the nearest integer.

Example:

INT(5.9) returns 5

INT(-5.1) returns -6

See also:

TRUNC, ROUNDDOWN, ROUNDUP, ROUND, MROUND, FIXED, EVEN, ODD, CEILING, FLOOR