One consequence of this behavior is that negative numbers becomemore negative.
For example, while INT(10.8) returns 10, INT(-10.8) returns -11.
To return an integer by truncating decimals, see theTRUNC function.
The INT function takes just one argument,number, which should be a numeric value.
INT returns a #VALUE!
error ifnumberis not a numeric value.
Ifnumberis already a whole number, INT has no effect.
However, TRUNC simply truncates a number, while INT actually rounds a number down to an integer.
With negative numbers, the results can be different.
INT(-3.1) returns -4, because INT rounds down to the lower integer.
TRUNC(-3.1) returns -3.
If you simply want the integer part of a number, you should use TRUNC.
For example, TRUNC(4.9) will return 4, and TRUNC(-3.5) will return -3.
The TRUNC function does no rounding, it simply truncates as specified.
Note that negative numbers becomemore negative.
For example, while INT(10.8) returns 10, INT(-10.8) returns -11.
ROUND Function
The Excel ROUND function returns a number rounded to a given number of digits.
The ROUND function can round to the right or left of the decimal point.
ROUNDDOWN Function
The Excel ROUNDDOWN function returns a number rounded down to a given number of places.
MROUND will round a number up or down, depending on the nearest multiple.
FLOOR Function
The Excel FLOOR function rounds a given number down to the nearest specified multiple.
FLOOR works like the MROUND function, but FLOORalways rounds down.
CEILING Function
The Excel CEILING function rounds a given numberupto the nearest specified multiple.
CEILING works like theMROUND function, but CEILINGalways rounds up.
