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

FACTDOUBLE(number)

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

 

Example of FACTDOUBLE Function in Excel

Formula

FACTDOUBLE FUNCTION IN EXCEL 1

  • 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

FACTDOUBLE FUNCTION IN EXCEL 2

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

previous FACTDOUBLE Function in Excel                                                                                                                next FACTDOUBLE Function in Excel