Quick Navigation

ODD Function

Excel 2007+

Summary

The Excel ODD function rounds a given number up to the nearest odd integer. It always rounds away from zero, making it perfect for ensuring values meet odd-number requirements in calculations like scheduling, inventory, or financial modeling.

Syntax

ODD(number)

Parameters

Parameter	Type	Required	Description
number	`Number`	Yes	The numeric value to round up to the nearest odd integer

Using the ODD Function

ODD is valuable when you need numbers to always be odd for business rules, scheduling, or calculations that require odd quantities. It consistently rounds away from zero regardless of the number's sign.

Common ODD Examples

Basic Rounding Examples

=ODD(1.5)

Rounds 1.5 up to 3 (nearest odd integer)

Already Odd Number

=ODD(3)

Returns 3 unchanged since it's already odd

Even Number Rounding

=ODD(2)

Rounds 2 up to 3

Negative Number Handling

=ODD(-2)

Rounds -2 away from zero to -3

Negative Odd Number

=ODD(-1)

Returns -1 unchanged

Frequently Asked Questions

ODD always rounds away from zero. -2 becomes -3, -1 stays -1.

Yes, it rounds decimals up to the next odd integer (1.5 → 3).

Returns #VALUE! error for non-numeric inputs.

Common Errors and Solutions

#VALUE!

Cause: Input is non-numeric (text, blank, or invalid)

Solution: Ensure the number argument contains a valid numeric value

Notes

Rounds away from zero regardless of sign
If number is already odd, returns unchanged
Use EVEN function for even integer rounding
Perfect for inventory counts, scheduling slots

Compatibility

Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365

Not available in:

Content last reviewed: December 11, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+