ODD function in Excel

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

  1. Click on an empty cell (like F5 )
empty cell in excel

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

 the fx icon in excel

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

insert function tab in excel

4. Select math and trig category

5. Select ODD function

6. Then select ok

math and trig function category in excel

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

odd function in excel

10. If you enter 2.5 result will be 3

odd function in excel

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

odd function in excel

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

odd function in excel

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:

Examples of ODD function in Excel
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?

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

What is the Return value of ODD function?

It returns a number.

How many arguments does ODD function have?

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?

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

Errors in ODD function

ODD related functions :

Leave a Reply

Your email address will not be published. Required fields are marked *