Excel functions / Math
FACTDOUBLE function
The double factorial: the number times every second whole number below it (7 × 5 × 3 × 1).
Syntax
=FACTDOUBLE(number)
Arguments
number: A whole number, -1 or more. Decimals are cut off.
When to use it
FACTDOUBLE gives the double factorial: the number times every second whole number below it. 7!! is 7 × 5 × 3 × 1 = 105.
Examples
Seven double factorial
A B C 1 n 2 7 105 In C2:
=FACTDOUBLE(A2)→ 105An even one: 6 × 4 × 2
A B C 1 n 2 6 48 In C2:
=FACTDOUBLE(A2)→ 48
Common mistakes
- Not the factorial twice. FACTDOUBLE(3) is 3, not FACT(FACT(3)), which is 720.
FACTDOUBLE in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: FACTDOUBLE
- Danish: DOBBELT.FAKULTET
- Dutch: DUBBELE.FACULTEIT
- Finnish: KERTOMA.OSA
- French: FACTDOUBLE
- German: ZWEIFAKULTÄT
- Hungarian: FAKTDUPLA
- Italian: FATT.DOPPIO
- Norwegian: DOBBELFAKT
- Polish: SILNIA.DWUKR
- Portuguese (Brazil): FATDUPLO
- Russian: ДВФАКТР
- Spanish: FACT.DOBLE
- Swedish: DUBBELFAKULTET
- Turkish: ÇİFTFAKTÖR
Try FACTDOUBLE in the playground
Related functions
- FACT: Factorial: 1 × 2 × … × n.
- MULTINOMIAL: The number of ways to split a group into smaller groups of the given sizes: the factorial of the total, divided by the factorial of each size.