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

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.

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.