Factorial in Google Sheets (Easiest Way to Calculate It in 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:

=FACT(number)

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).

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.

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.