How to Do Factorials in Google Sheets


Factorial is a mathematical term which says that product of all positive integers less than or equal to a given positive integer, indicated by that integer and an exclamation point.

As a result, factorial seven can be expressed as 7! which means 1*2*3*4*5*6*7 i.e., product of all positive integers less than or equal to a number. I am taking seven and multiply the number by all the positive integers below that number down to 1.

FACT Function in Google Sheets

In order to calculate factorials, Google Sheets provide us with a specific function called FACT function.

The syntax for this function is –

=FACT(value), here

value, it contains the number or cell reference that contains the number that you want to calculate factorial for.

FACT function

Here, from the above image example we can see that how we just need to put a cell reference of the number for which we want to calculate factorial and our work is done.

This is a really basic function to use, so you shouldn’t have any trouble picking it up quickly.
Thus this is unquestionably faster than manually multiplying each integer!

Harshita Mathur

My name is Harshita Mathur. I come from Jaipur, Rajasthan. I am a law student. Apart from this I am an amateur writer.

Recent Content