Excel Functions Tutorials
- Maths Functions in Excel
- ABS Function in Excel
- AGGREGATE Excel Function
- CEILING Excel Function
- COMBIN Excel Function
- COS Excel Function
- EVEN Function in Excel
- EXPONENTIAL Excel Function
- Excel Matrix Multiplication
- Excel Minus Formula
- FLOOR Function in Excel
- Histogram Formula
- INT Excel Function (Integer)
- LN Excel Function
- LOG Excel Function
- Mode in Excel
- ODD Function in Excel
- POWER Function in Excel
- PRODUCT Excel Function
- PRODUCT Formula in Excel
- PI in Excel
- Quotient in Excel
- Running Total in Excel
- RAND Excel Function
- Rand Excel Formula
- RANDBETWEEN in Excel
- MROUND in Excel
- ROUND in Excel
- ROUND Formula in Excel
- ROUNDDOWN Excel Function
- ROUNDUP Function in Excel
- SIGN Excel Function
- SIN Excel Function
- Square Root in Excel (SQRT)
- SUBTOTAL Excel Function
- SUM Function in Excel
- SUM Formula in Excel
- Excel SUM Shortcut
- SUMIF in Excel
- SUMIFS in Excel
- SUMIF Not Blank
- SUMIFS with Dates
- SUMIF Between Two Dates
- Sumif Text in Excel
- SumIf with Multiple Criteria
- SUMPRODUCT Function in Excel
- SUMPRODUCT Formula in Excel
- SUMPRODUCT with Multiple Criteria
- How to Sum Multiple Rows in Excel?
- TAN Excel Function
- TANH in Excel
- Average vs Weighted Average
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tools (98+)
- Excel Tips (178+)
- VBA (162+)
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.
In this 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.
In this 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.
In this 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.
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 ODD Function in Excel
- 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.
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 –