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:

`=ODD (num)`

**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.

## Leave a Comment