What is the syntax for FACTDOUBLE in Excel?

The syntax for FACTDOUBLE is: =FACTDOUBLE(number)

How do I use the FACTDOUBLE function?

To use FACTDOUBLE, type =FACTDOUBLE( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.

What happens if FACTDOUBLE encounters errors?

If FACTDOUBLE encounters invalid arguments or calculation errors, it may return error values like #VALUE!, #NUM!, or #DIV/0!. Check your input values and ensure they meet the function's requirements.

Why is FACTDOUBLE not working in my Excel?

Common issues with FACTDOUBLE include #NUM! if number < 0. Start by checking the syntax =FACTDOUBLE(number), then verify each referenced cell or range.

Math & Trig

FACTDOUBLE Function in Excel

Q: What is the FACTDOUBLE function in Excel?

Returns the double factorial of a number.

Syntax

=FACTDOUBLE(number)

Arguments

number (required): Non-negative integer

Examples

=FACTDOUBLE(6) - 6!! = 6*4*2 - Result: 48

FACTDOUBLE in reporting workflows

Use absolute references when copying formulas across rows.
For conditional totals see [SUMIF](/functions/sumif/) and [SUMIFS](/functions/sumifs/).
Filtered lists may need [SUBTOTAL](/functions/subtotal/) instead of SUM on visible cells only.

Common errors

#NUM! if number < 0

Use cases

Advanced mathematics
Physics
Combinatorics

Frequently asked questions

What is the FACTDOUBLE function in Excel? FACTDOUBLE returns the double factorial of a number. The syntax is =FACTDOUBLE(number). Typical use cases include advanced mathematics, physics, combinatorics.
How do I use the FACTDOUBLE function? To use FACTDOUBLE, type =FACTDOUBLE( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
What happens if FACTDOUBLE encounters errors? If FACTDOUBLE encounters invalid arguments or calculation errors, it may return error values like #VALUE!, #NUM!, or #DIV/0!. Check your input values and ensure they meet the function's requirements.
Why is FACTDOUBLE not working in my Excel? Common issues with FACTDOUBLE include #NUM! if number < 0. Start by checking the syntax =FACTDOUBLE(number), then verify each referenced cell or range.

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.