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.
The TRUNC function takes twoarguments:numberandnum_digits.Numberis the numeric value to truncate.
Thenum_digitsargument is optional and specifies the place at whichnumbershould be truncated.Num_digitsdefaults to zero (0).
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.
Note that negative numbers becomemore negative.
For example, while INT(10.8) returns 10, INT(-10.8) returns -11.
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.
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.
CEILING Function
The Excel CEILING function rounds a given numberupto the nearest specified multiple.
CEILING works like theMROUND function, but CEILINGalways rounds up.
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.
ODD Function
The Excel ODD function returns the next odd integer after rounding a given number up.
EVEN Function
The Excel EVEN function rounds numbers up to the next even integer.
