Share via


WorksheetFunction.FactDouble Method

Returns the double factorial of a number.

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

Syntax

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

returnValue = instance.FactDouble(Arg1)
double FactDouble(
    Object Arg1
)

Parameters

  • Arg1
    Type: System.Object

    Number - the value for which to return the double factorial. If number is not an integer, it is truncated.

Return Value

Type: System.Double

Remarks

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

If number is negative, FactDouble returns the #NUM! error value.

If number is even:

Figure 1: Equation for even

Equation for even

If number is odd:

Figure 2: Equation for odd

Equation for odd

See Also

Reference

WorksheetFunction Interface

WorksheetFunction Members

Microsoft.Office.Interop.Excel Namespace