ODD takes just oneargument,number, which should be a numeric value.
With positive numbers, ODD roundsnumberup to the next odd integer.
With negative values, ODD roundsnumberdown away from zero to the next odd negative integer.
With one (1) and numbers that are already odd integers,numberis unchanged.
ODD Function
The Excel ODD function returns the next odd integer after rounding a given number up.
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.
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.
