Math and Trignometric - ODD Function
Advertisements
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
advanced_excel_math_trigonometric_functions.htm
Advertisements