Formulas > =FACT()

How To Use FACT() Function in Google Sheets


Returns the factorial of a number.

Common questions about the FACT Formula include:
  • What is the FACT formula?
  • How does the FACT formula work?
  • What do the parameters of the FACT formula mean?

The FACT formula can be used to quickly calculate a factorial, which is the product of all positive integers from 1 to a given number. For example, FACT(6) will return 720, the product of all positive integers from 1 to 6.

The FACT formula can be commonly mistyped by substituting the "CT" for "EC" or vice versa, resulting in an invalid formula.

Some common ways the FACT formula is used inappropriately include using the formula on a negative number, using it to calculate something other than a factorial, or using it for a problem that could be resolved much more efficiently using another approach.

Common pitfalls when using the FACT formula include using it with a large number that returns an incorrect value (due to the limitations of Google Sheets’ number of significant digits), entering a non-numeric value, or not typing a number as the parameter.

Common mistakes when using the FACT Formula include using parentheses instead of delimiters (commas) or omitting the formula altogether.

Common misconceptions people might have with the FACT Formula include thinking it can be used to calculate the square root of a number, or that it takes multiple parameters.

How To Actually Use FACT() 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 FACT() formula:

FACTDOUBLE vs FACT in Q function's Taylor Maclaurin SERIESSUM & LINEST Polynomial Regression

This video shows the use of FACTDOUBLE, FACT, SERIESSUM, NORMSDIST, LINEST, ARRAYFORMULA, Taylor Series, Maclaurin Series, Expansion & , Polynomial Regression of the Q function Excel, Google Sheets.

Generate a FACT() 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.


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.