The Excel ODD function rounds a number up (away from zero) to the nearest odd integer — the odd-number counterpart of EVEN.
Syntax
| Argument | Description | |
|---|---|---|
number | Required | The number you want to round up to the nearest odd integer. |
How to use it
ODD rounds away from zero to the next odd whole number. Any value that isn't already an odd integer bumps up to the next one:
Because it rounds away from zero, negative inputs go to the more negative odd number. An input already odd (like 3) is returned unchanged. ODD is the odd-number counterpart of EVEN.
1.5 jumps to 3, not 1. ODD rounds up to the next odd integer, so any fraction past 1 pushes the result to 3. Note that =ODD(0) returns 1, since 0 rounds up to the first positive odd number.
Try it: interactive demo
Pick a ODD example to see the formula and its result.
Practice workbook
Frequently asked questions
Does ODD round to the nearest odd number?
=ODD(1.5) is 3, not 1.How does ODD handle negative numbers?
=ODD(-2) returns -3, the more negative odd number.What does ODD return for zero?
=ODD(0) returns 1 — zero rounds up to the first positive odd integer.What's the difference between ODD and EVEN?
Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class