WorksheetFunction.Odd Method

Returns number rounded up to the nearest odd integer.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function Odd ( _
    Arg1 As Double _
) As Double
'Usage
Dim instance As WorksheetFunction
Dim Arg1 As Double
Dim returnValue As Double

returnValue = instance.Odd(Arg1)

double Odd(
    double Arg1
)

Parameters

• Arg1
  Type: System.Double

  Number - the value to round.

Return Value

Type: System.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.

See Also

Reference

WorksheetFunction Interface

WorksheetFunction Members

Microsoft.Office.Interop.Excel Namespace