Excel ODD Function

The Excel ODD function returns number rounded up to the nearest odd integer. The ODD function always rounds away from zero, so positive numbers become larger and negative numbers become smaller. If number is an odd integer, no rounding occurs.

The ODD function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function in Excel. As a worksheet function, the ODD function can be used as part of a formula in a worksheet cell.

Syntax

ODD(number)

Parameters

Return Value

Returns number rounded up to the nearest odd integer.

Notes

• If the argument is a non-numeric value, ODD returns #VALUE! error.

Example: Using as Worksheet Function

The example below shows how to use the ODD function as worksheet function.

Based on the Excel spreadsheet above, the output of the following worksheet formula will be:

=ODD(B5)
Result: 1

=ODD(B6)
Result: 3

=ODD(B7)
Result: 3

=ODD(B8)
Result: 1

=ODD(B9)
Result: -1

=ODD(B10)
Result: -3

=ODD(B11)
Result: -3