**Excel ODD Function (Table of Contents)**

## ODD Function in Excel

It’s a worksheet function in Excel, an ODD function is an inbuilt function in Excel that is categorized under Math & Trigonometry Function.

In the excel sheet, this function will come under the Math & Trig command button’s drop-down menu on the ribbon formula tab.

Its main purpose is to round up a number to the nearest ODD integer, so positive numbers will become larger and negative numbers will become smaller (i.e. more Negative).

This function will skip even integer every time & returns odd integer or value.

It returns number rounded up to the nearest odd integer.

### ODD Formula in Excel

Below is the ODD Formula in Excel :

It includes only one argument i.e. number.

**Number**– It is the number we wish to round up to an odd integer.

**How to Use ODD Function in Excel?**

It is very simple and easy to use. Let understand the working of this function by some example.

4.8 (2,200 ratings)

View Course

### Example #1 – ODD Function on Positive Point Values

Suppose in a worksheet, the cell “B6” contains value 245.25.

If you use an odd function on this, i.e. **=ODD(B6)**.

In number argument here we simply enter the value “245.25” directly into the formula or reference a cell containing a number i.e. (B6).

**Note:** Numeric value of the cell should be always used in the double quotations i.e. “245.25”.

In the output or result, Excel rounds the value up to the next odd whole number, and returns the value 247, because it is the next highest odd number.

### Example #2 – On ODD Number

If a number is an odd integer, no rounding occurs, it returns the same value.

Suppose in a worksheet, the cell “B11” already contains ODD number i.e. “5”.

If this function is applied to this, i.e. =ODD(B11)

In number argument here we have to simply enter the value “5” in double quotation directly into the formula, or reference a cell containing a number i.e. (B11)

In the output or result, it returns the same value, no rounding occurs in this case.

### Example #3 – On Positive Integers

Suppose in a worksheet, the cell “B16” contains positive integer “20”.

This function is applied to this, i.e. =ODD(B16).

In number argument here we have to simply enter the value “20” in double quotation directly into the formula, or reference a cell containing a number i.e. (B16).

In the output or result, Excel rounds the value up to the next odd whole number, and returns the value 21, because it is the next highest odd number.

### Example #4 – On Negative Integers

It will round up value to the nearest odd number (i.e. more Negative value)

Suppose in a worksheet, the cell “B21” contains Negative integer “-36”.

This function is applied to this, i.e. =ODD(B21).

In number argument here we have to simply enter the value “-36” in double quotation directly into the formula, or reference a cell containing a number i.e. (B21).

In the output or result, Excel rounds the value up to the nearest odd number (i.e. more Negative value) and returns the value -37.

### Example #5 – Odd Function on Zero

If a number is 0 (zero), ODD Function rounds to the positive value +1.

Suppose in a worksheet, the cell “G6” contains the value Zero or “0”.

This function is applied to this, i.e. **=ODD(G6)**.

In number argument here we have to simply enter the value “0” in double quotation directly into the formula, or reference a cell containing a number i.e. (G6).

In the output or result, Excel rounds to the positive value +1 and returns the value 1.

### Example #6 – On Negative Point Values

Suppose in a worksheet, the cell “G11” contains negative point value -3.4.

If you use an odd function on this, i.e. =ODD(G11).

In number argument here we have to simply enter the value “-3.4” directly into the formula or reference a cell containing a number i.e. (G11).

In the output or result, Excel rounds the value up to the nearest odd number (i.e. more Negative value) and returns the value -5.

### Example #7 – ODD Function On Non-Numeric or Text Values

If a number is non-numeric or text value, this function returns the #VALUE! Error.

Suppose in a worksheet, the cell “G16” contains the word “EXCEL”.

If you use an odd function on this, i.e. =ODD(G16).

In number argument here we have to simply enter the value “EXCEL” in double quotation directly into the formula, or reference a cell containing a number i.e. (G16).

In the output or result, it returns the #VALUE! Error, because it is a text or non-numeric value.

### Example #8 – On Decimal Values or Value Smaller than One

Suppose in a worksheet, the cell “G21” contains the value “0.03”, i.e. value smaller than one.

If you use an odd function on this, i.e. =ODD(G21)

In number argument here we have to simply enter the value ““0.03” in double quotation directly into the formula, or reference a cell containing a number i.e. (G21).

In the output or result, Excel rounds the value up to the nearest odd number and returns the value 1.

**Things to Remember About ODD Function in Excel**

- If the supplied number argument is not recognized as a numeric value by MS Excel. i.e. If a number is nonnumeric, the function returns the #VALUE! Error.

- If a number is 0 (zero), this Function rounds to the positive value +1.

- If a number is an odd integer, no rounding occurs, it returns the same value.

- ISODD FUNCTION is different from an ODD function, ISODD FUNCTION evaluates whether the reference or number in a cell is an ODD number.

### Recommended Articles

This has been a guide to ODD Function. Here we discuss the ODD Formula and How to use ODD Function along with an Examples and downloadable excel templates. You may also look at these useful functions in excel –