Excel FunctionsExcel ODD Function


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.


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.


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.


Organically grow the holistic world view of disruptive innovation via empowerment.
OUR LOCATIONSWhere to find us
GET IN TOUCHSocial links
Taking seamless key performance indicators offline to maximise the long tail.

Copyright by Excel Accountancy. All rights reserved.

Copyright by BoldThemes. All rights reserved.