ODD

See also A-Z Spreadsheet Function List

Description Rounds the specified number up to the nearest odd integer.

Syntax ODD(number)

number is any number, a formula that evaluates to a number, or a reference to a cell that contains a number.

See Also CEILING , EVEN , FLOOR , INT , ROUND , and TRUNC functions

Examples ODD(3.5) returns 5

         ODD(6) returns 7