# ODD function

Excel ODD Function is a useful tool for rounding numbers up to the nearest odd integer. It’s particularly handy when you need to work with data that requires odd values, such as scheduling or inventory management.

ODD(number)

## How to Use

To use the ODD function, follow these simple steps:

1. Start by selecting the cell where you want the rounded odd number to appear.
2. Enter the following formula into the selected cell.
=ODD(number) Replace “number” with the actual value you want to round up to the nearest odd integer.
3. Press Enter, and the cell will display the result, which is the nearest odd integer greater than or equal to the given number.

Here are a couple of examples to illustrate how the ODD function works:

This formula rounds 5.2 up to the nearest odd integer, which is 7.

Here, the formula rounds 10 up to the nearest odd integer, which is 11.

If you want to round a negative number, the ODD function still works the same way:

This formula rounds -3.7 up to the nearest odd integer, which is -3.