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

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

  1. Seven double factorial

    ABC
    1n
    27105

    In C2: =FACTDOUBLE(A2) → 105

    Try this example

  2. An even one: 6 × 4 × 2

    ABC
    1n
    2648

    In C2: =FACTDOUBLE(A2) → 48

    Try this example

Common mistakes

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.

Translate a whole formula

Try FACTDOUBLE in the playground

Related functions