Microsoft® Excel® 2010 Formulas & Functions Inside Out

ODD()

Syntax. ODD(number)

Definition. This function rounds a number up to the nearest odd integer.

Argument

• number (required) The value to round

Background. All numbers that cannot be divided by 2 are odd numbers. The ODD() function uses only numeric values. If a number isn’t a numeric expression, the ODD() function returns the #VALUE! error.

Regardless of the sign of number, the value is rounded up when adjusted based on zero. If number is an odd integer, no rounding occurs.

More examples for this function are:

• =ODD(1.9) returns 3.

• =ODD(-2.8) returns -3.

• =ODD(18) returns 19.

See Also

CEILING(), CEILING.PRECISE(), EVEN(), FLOOR(), FLOOR.PRECISE(), INT(), ISEVEN(), ISODD(), ROUND(), TRUNC()

Sample Files

Use the ROUND worksheet in the Chapter16.xls or Chapter16.xlsx ...