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

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

ODD Function in Excel 1

  • 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

ODD Function in Excel 2

previous-small ODD Function in Excel                                                                                                                next_small ODD Function in Excel