Excel function · Statistics

ODD

Rounds a number up to the next odd whole number.

What it does

ODD rounds a number away from zero to the nearest odd whole number: 6 becomes 7, 7.2 becomes 9, -2 becomes -3. An odd whole number stays as it is.

=ODD(number)

Arguments in square brackets are optional, and … means you can add more of the same. In this Excel language, arguments are separated by ,

A panel of judges needs an odd number so a vote can't tie. How many judges from 6 volunteers?

	A	B
1	Volunteers	Judges
2	6	7

The formula in B2:

=ODD(A2)

Result: 7

6 is even, so it is rounded up to the next odd number: 7.

Expecting it to round to the nearest odd number. It always rounds up (away from zero): 7.2 becomes 9, not 7.
Using it to test whether a number is odd. Use MOD(A2,2)=1 for that.

Excel translates function names, and in some languages the argument separator too. Type the name your Excel shows.