Excel ODD Function (Table of Contents)
ODD Excel Function
This function is categories as Math function in excel rounds a number to a nearest odd integer.
This can be used round a number up to nearest odd integer and it will round the number up away from zero so if you round the positive numbers becomes larger and negative numbers become smaller.
ODD Excel Function Definition
The ODD rounds a positive number up and a negative number down. As a financial analyst, ODD formula is a very useful excel function, as it helps round a number/value and makes it an ODD value. This function removes the least significant digits and simplifying the notation but keeping close to the original value.
ODD Formula in Excel
The ODD excel formula has only one compulsory parameter i.e. number.
- number: A numeric value that will be rounded up to the nearest odd integer.
How to Use the ODD Formula in excel?
This function is very simple and easy to use. Let understand the working of this function by some ODD Function examples. This can be used as a worksheet function and as VBA function.
ODD excel Formula as worksheet function.
ODD Excel Function Example #1
In this ODD function in Excel example, let’s consider a set of positive integers 40, 18, 10, 26, 19, 20, 14, 17, 30 and 27 to understand the working on ODD. Now apply the ODD excel Formula in the cell as shown in the below table. This function will round up all values to the nearest odd numbers as 41, 19, 11, 27, 19, 21, 15, 17, 31 and 27.
ODD Function in Excel Example #2
In this ODD function example, we take the sample of negative integers and then apply the ODD excel formula on them.
Let’s consider a set of positive integers -40, -18, -10, -26, -19, -20, -14, -17, -30 and -27 to understand the working on ODD. Now apply the ODD Formula in cell as shown in the below table. This function will round up all values to the nearest odd numbers as -41, -19, -11, -27, -19, -21, -15, -17, -31 and -27.
ODD Excel Function Example #3
In this ODD function example let’s take positive point values for the ODD.
Here point value first round off to near integer value than odd works. For value 27.9 the odd return the 29 as output because 27.9 first considered as >27 ~ 28 then odd rounded up to the nearest integer value.
For the below table values 40.18, 18.1, 10.26, 26.19, 19.19, 19.14, 14.17, 17.3, 30.27 and 27.9 the output will be 41, 19, 11, 27, 19, 21, 15, 17, 31 and 29.
ODD Excel Function Example #4
In this ODD function example let’s take negative point values for the ODD.
Let’s consider a set of negative point values -40.18, -18.1, -10.26, -26.19, -19.19, -19.14, -14.17, -17.3, -30.27 and -27.9 to understand the working on ODD. Now apply the ODD formula in cell as shown in the below table. This function will round up all values to the nearest odd numbers as -41, -19, -11, -27, -21, -21, -15, -19, -31 and -29.
The ODD can be used as a VBA function.
Dim ODDnumber As Long
ODDnumber = Application.worksheetfunction.odd(“14”)
Msgbox(ODDnumber) // Return the nearest odd value in message box.
The output will be “15” and printed in the message box.
Things to Remember About the ODD
- If the supplied number is non-numeric value then the ODD will return the #VALUE! Error.
- Irrespective of the value (+ve and –ve) of number, a value is rounded up and adjusted away from zero.
- If the number is an odd integer, no rounding occurs.
You can download this ODD Function in Excel template here – ODD Function Excel Template
This has been a guide to ODD Excel Function. Here we discuss the ODD Formula in excel and how to use ODD in Excel along with excel ODD Function example and downloadable excel templates. You may also look at these useful functions in excel –