Math and Trignometric - ODD Function

Description

The ODD function returns number rounded up to the nearest odd integer. ODD Function is one of fifteen rounding Functions in Excel.

Syntax

ODD (number)

Arguments

Argument Description Required/Optional
Number The value to round. Required

Notes

  • Regardless of the sign of number, a value is rounded away from zero to the next odd number.

  • If number is an odd integer, no rounding occurs.

  • If number is 0 (zero), ODD Function rounds to the positive value +1.

  • If number is nonnumeric, ODD returns the #VALUE! error value.

Applicability

Excel 2007, Excel 2010, Excel 2013, Excel 2016

Example

ODD Function
advanced_excel_math_trigonometric_functions.htm
Advertisements