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
ODD (number)
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