The ODD function in Excel is used to return the next odd integer value after rounding any given number. The ODD function always rounds up the numbers in such a way that the positive numbers become larger and negative numbers become smaller.
The main purpose of the function is to round a number to the next odd integer value and the result is the rounded number.
Figure 1: Excel ODD Function
The syntax of the function
The syntax of the function is as follows:
The arguments present in the syntax are:
- Num: it is the number that needs to be rounded up into the next integer
use of the function
The ODD function in Excel always rounds up the numbers to the nearest odd number and skips all the even integers. Note that when using the ODD function with negative numbers, the values are always rounded away from zero to becoming more negative.