In this article:

Factorial in Google Sheets (Easiest Way to Calculate It in 2024)

May 8, 2024

How to Do a Factorial in Google Sheets

To calculate factorials in Google Sheets, you can use the FACT function. The syntax for the FACT function is as follows:


Here's how to apply it in Google Sheets:

Step 1: Select a Cell

Click on the cell where you want the result of the factorial calculation to appear. Let's say, B1.

Step 2: Enter the FACT Function

Type the FACT function into the selected cell. 

For example, if you want to calculate the factorial of 5 (in cell A1), you will enter =FACT(A1) into the cell. You can also simply enter =FACT(5).

google sheets factorial

Step 3: Press Enter

After typing in the formula, press Enter. Google Sheets will automatically calculate the factorial and display the result in the selected cell.

Following our example, Google Sheets should display 120 in the cell. This is because 5 factorial (5!) equals 5 x 4 x 3 x 2 x 1, which is 120.

factorial google sheets

We hope that this article has helped you and given you a better understanding of how to do a factorial in Google Sheets. If you enjoyed this article, you might also like our articles on how to find the second highest value in Google Sheets and how to use the DCOUNT function in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->