FACTDOUBLE Function in Excel

FACTDOUBLE Function in Excel returns the double factorial of a given number. Double Factorial can be calculated as follows.

If N is even then Double Factorial of N will be

                                N * (N-2) * (N-4) * …. 6* 4 * 2

If N is odd then Double Factorial of N will be

                                N * (N-2) * (N-4) * ….5 * 3 * 1

Syntax of FACTDOUBLE Function in Excel

Where number is the Positive number that you want to calculate the Double Factorial of.

 

Example of FACTDOUBLE Function in Excel

Formula

• Row number 2 and 3 calculates the double factorial of even numbers
• Row number 4 and 5 calculates the double factorial of odd numbers

Result

#NUM! Error occurs if the supplied number argument is negative.