Skip to Content

How to Do Factorials in Google Sheets

There are a few different ways to do factorials in Google Sheets.

The easiest method is to use their built-in FACT function.

In this tutorial, I will show you how to factorials by using the FACT function in Google Sheets.

What is a Factorial?

In math, a factorial is the product of all positive integers less than or equal to a number.

For example, factorial five is equivalent to:

5 x 4 x 3 x 2 x 1

This is what I mean by the product of all positive integers less than or equal to a number. I am taking five and multiply the number by all the positive integers below that number down to 1.

You will commonly see factorials written with an exclamation point. So factorial five would be written as 5!

FACT Function in Google Sheets

In Google Sheets, there is an easy way to calculate factorials with the FACT function.

The syntax of the FACT function is:

=FACT(value)

  • Value – this is the number or cell reference that contains the number that you want to calculate factorial for

Here is an example of how it can be used in a spreadsheet:

FACT function

You can see in the above example, the formula is very simple to set up. Just put in the cell reference containing the number that you want to calculate the factorial for.

Closing Thoughts

This is a very simple function to use, so it shouldn’t take you long to get down.

There is only one argument to the formula, which is the number or cell reference containing the number to do the factorial for.

This is definitely much faster than multiplying each integer together manually!

More Google Sheets Tutorials:
How to Use the Quotient Function