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
- 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.