ODD Function in Excel – Round up to the nearest Odd number in Excel

ODD function in Excel returns the next odd integer after rounding a given number up. Please note that odd function always rounds numbers up (away from zero)

• Positive number becomes more positive
• Negative number becomes more negative

Syntax of ODD Function in Excel

Number is a numeric value that you want to round up to the nearest odd integer

Example of ODD Function in Excel

Formula

• For value in Row number 2 when rounded up, the nearest odd integer will be 5
• For Row number 3 the nearest rounded up odd integer will be 3(moving away from zero)
• For Row number 4 the nearest rounded up odd integer will be -3(moving away from zero)

So the result will be

Result