Description
The Excel ODD function rounds up any referred number to the nearest ODD number.
(In the example given in the image above, 29.55 is rounded up to 31).
Excel ODD function belongs to the rounding functions, which rounds the fractional numbers to the nearest integers.
However, unlike the INT function (in which fractional numbers are rounded down to the nearest Integer), this function rounds up the numbers.
NOTE:
Remember that the Excel ODD function is different from the ISODD function, which is a conditional function and returns the logical values (TRUE/ FALSE) if the given criteria are met.
=ODD(number)
The ODD function’s syntax has the following argument:
- number Required.
This argument shall be the number (even stored as text) or reference to the number you want to round. In the example given in the image above the number “29.55” and the cell B3 (i.e. reference to the number) is our required argument.
