WorksheetFunction.Odd Method (Excel)
Returns number rounded up to the nearest odd integer.
Syntax
expression .Odd(Arg1)
expression A variable that represents a WorksheetFunction object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Arg1 |
Required |
Double |
Number - the value to round. |
Return Value
Double
Remarks
If number is nonnumeric, ODD returns the #VALUE! error value.
Regardless of the sign of number, a value is rounded up when adjusted away from zero. If number is an odd integer, no rounding occurs.