ExcelFlux

FACTDOUBLE function

the double factorial of a number.

Math and trigonometry

Where can you use it?

Reporting, manufacturing and engineering teams. When a total, rounding step or numerical transformation is needed, use the example to see which operation fits your inputs.

Scenario in the workbook

Multiply descending values of the same parity. Five uses 5×3×1.

A worked example from the workbook

RowA
6Input
74
85
97
Record 1
=FACTDOUBLE(A7)

Expected result8

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=FACTDOUBLE(7)
Turkish Excel · tr-TR
=ÇİFTFAKTÖR(7)

Expected result

105

Worked examples

Multiply descending values of the same parity. Five uses 5×3×1.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A
6 Input
7 4
8 5
9 7
Case Formula Expected result
Record 1 =FACTDOUBLE(A7) 8
Record 2 =FACTDOUBLE(A8) 15
Record 3 =FACTDOUBLE(A9) 105
Microsoft Excel reference