Excel: Odd Function

In Excel, the Odd function rounds a number up to the nearest odd integer. If the number is negative, the number is rounded away from zero.

The syntax for the Odd function is:

Odd( number )

number is a numeric value.

Applies To:

For example:

Let's take a look at an example:

Based on the Excel spreadsheet above:

=Odd(A1) would return 211

=Odd(A2) would return 3

=Odd(A3) would return -3

=Odd(7) would return 7