ODD Function In Excel - Formula, Example, How To Use?

What Is ODD Function In Excel?

The ODD Function in Excel rounds the numeric values in a dataset to its nearest odd number away from zero. On a number scale, it rounds up toward the right for a positive integer input and toward the left for a negative integer input.

The ODD Excel function is an inbuilt Math & Trig function, so we can insert the formula from the “Function Library” or enter it directly in the worksheet.

📥Download the ready-to-use Excel template to practice this tutorial yourself.

Download Excel Template

For example, the image below depicts the Values in column A. We will apply the ODD Excel Function to find the absolute values as the output.

Frequently Asked Questions (FAQs)

1. What does the ODD function do in Excel?

The ODD Function in Excel finds and returns the odd numbers in a series of numbers.

The syntax of the ODD function is =ODD(number)

2. How does the ODD function work?

The Excel ODD Function works as shown below.
1) Select an empty cell for the output.
2) Type =ODD( in the selected cell. [Alternatively, type =O and double-click and then the ODD function from the list of suggestions shown by Excel.]
3) Enter the arguments as cell values or cell references and close the brackets.
4) Press the “Enter” key.
For example, using the ODD Excel Function, we will find the odd value for the average of the given values.

In the table, the data is,
• Column A contains the Value.
• Column B contains the ODD Result.

The procedure to find the value by the ODD formula is,

Select cell B2, enter the formula =ODD(AVERAGE(A2:A6), and press the “Enter” key.

The result is “-21”, as shown above.

3. Where is the ODD Function in Excel?

The ODD Function in Excel is found and inserted as follows:

Choose an empty cell → select the “Formulas” tab → go to the “Function Library” group → click the “Math & Trig” option drop-down → select the “ODD” function, as shown below.

Download Template