WorksheetFunction.FactDouble method (Excel)

  • Article

Returns the double factorial of a number.

Syntax

expression.FactDouble (Arg1)

expression A variable that represents a WorksheetFunction object.

Parameters

Name Required/Optional Data type Description
Arg1 Required Variant Number - the value for which to return the double factorial. If number is not an integer, it is truncated.

Return value

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:   Screenshot of the Fact Double equation when the number is even.

If number is odd:   Screenshot of the Fact Double equation when the number is odd.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.