## What is ODD function in Excel?

The **ODD** function is one of the math functions of Excel.

It **Rounds **a positive number **up** and **negative **number **down** to the Nearest ODD integer.

We can find this function in **Math & trig** category of insert function Tab.

## How to use **ODD** function in excel

- Click on an
**empty**cell (like F5 )

2. Click on the **fx icon **(or press shift+F3)

3. In the **insert function tab** you will see all functions

4. Select **math and trig** category

5. Select **ODD** function

6. Then select** ok**

7. In function Arguments Tab you will see **ODD** function

8. Number section is the **value to round **

9. If you enter **+1.5** result will be **3**

10. If you enter **2.5 **result will be **3**

11. If you enter **-1.5 ** result will be ** -3**

12. If you enter **-2.5** result will be **-3**

13. You will see **results **in the formula result section

## Examples of **ODD** function in Excel

**Example 1:**

**How to Find ODD numbers in excel**?

You can see examples of ODD function below:

**odd**(0.5) ----->>>>answer is 1
**odd**(1.5) ----->>>>answer is 3
**odd**(-1.5) ----->>>>answer is -3
**odd**(-0.5) ----->>>>answer is -1
**odd**(0) ----->>>>answer is 1

## What is the purpose of **ODD** function?

**ODD**

It **Rounds **a positive number **up** and **negative **number **down** to the Nearest ODD integer.

## What is the Return value of **ODD** function?

**ODD**

It returns a number.

## How many arguments does **ODD** function have?

**ODD**

This function has just **1** Argument.

The **argument **of ODD function is **number**.

Number section is the **value to round**.

The argument of ODD function is **required **and not optional.

```
ODD(number) = number
```

## Which version of excel supports **ODD** function?

**ODD**

This function is available for all excel **versions **(2003-2019)

## Errors in **ODD** function

**ODD**

**ODD related functions :**

- EVEN Function
- ROUND Function
- MROUND Function
- FLOOR Function
- INT Function
- ROUNDUP Function
- ROUNDDOWN Function
- CEILING function
- TRUNC function