Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
ODD
ODD rounds a number away from zero to the nearest odd integer. It complements EVEN and is handy in scenarios where odd quantities are structurally required, such as certain statistical sampling schemes.
Excel
=ODD(2)Google Sheets
=ODD(2)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Value | Rounded Odd |
| 2 | =ODD(2) |
| 4 | =ODD(4) |
| 5 | =ODD(5) |
| -2 | =ODD(-2) |
=ODD(2)→3
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Supply the number you want to round: =ODD(number).
- 2ODD rounds away from zero to the nearest odd integer (e.g., 2 → 3, -2 → -3).
- 3Use the resulting odd integer in your formula or calculation.