ODD Function
Rounds a number up to the nearest odd whole number.
Category
Math & Trig
Available in
All versions, Microsoft 365
Returns
A whole number
Want to practice ODD in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
ODD rounds away from zero to the next odd integer: 2 → 3, 3 → 3, 3.2 → 5, −2 → −3.
A typical use is making sure a committee or panel has an odd number of members so votes can't tie.
Syntax
=ODD(number) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number | Yes | The value to round. |
Examples
Example 1 — Tie-proof panels
Round panel sizes up to an odd number.
B2fx=ODD(A2)
| A | B | |
|---|---|---|
| 1 | Requested | Panel size |
| 2 | 4 | 5 |
| 3 | 5 | 5 |
| 4 | 6.5 | 7 |
=ODD(A2) Explain
Common mistakes
- Zero. ODD(0) is 1.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.