Formulas > =FACTDOUBLE()

How To Use FACTDOUBLE() Function in Google Sheets


Returns the "double factorial" of a number.

Common questions about the FACTDOUBLE formula include:
- What is the FACTDOUBLE formula?
- How does the FACTDOUBLE formula work?
- What does the FACTDOUBLE formula do?

The FACTDOUBLE formula can be used to calculate the double factorial of a number. This formula can be used appropriately by entering a number (positive, negative, or zero) into the formula, and letting the worksheet calculate the double factorial.

The FACTDOUBLE formula is commonly mistyped by users as "FACTOIDDOUBLE," which is an invalid formula that will return an error. It can also be mistyped as FACTDOUBEL, FACTDUBLE, FACTDOUBL, FACTDUOBLE.

Common ways the FACTDOUBLE formula is used inappropriately include using the formula on non-numeric values, such as text, or on non-integer values (such as fractions or decimals). 

Common pitfalls when using the FACTDOUBLE formula include attempting to use it on numbers that are too large for the worksheet to process, or assuming that the formula will calculate the factorial of a number, as opposed to a double-factorial.

Common mistakes when using the FACTDOUBLE formula include accidentally entering an incorrect formula, such as "FACTOIDDOUBLE," instead of the correct formula, or accidentally entering non-numeric values in the formula.

Common misconceptions people may have with the FACTDOUBLE formula are to assume that it calculates the factorial of a number, as opposed to a double-factorial. Additionally, some people may mistakenly think that the FACTDOUBLE formula cannot be used on negative numbers, when in fact it can.

How To Actually Use FACTDOUBLE() in Sheets


Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the FACTDOUBLE() formula:

FACTDOUBLE FACT GAMMA x*e^(-x) Taylor Maclaurin SERIESSUM LINEST Polynomial Regression Google Sheets

This video shows the use of FACTDOUBLE, FACT, GAMMA, EXP, ARRAYFORMULA, SERIESSUM, LINEST, in, Taylor Series, Maclaurin Series, Expansion and, Polynomial Regression, of x*e^(-x)

Generate a FACTDOUBLE() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members. Free to try for non-members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.