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

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

link to Format Phone numbers in Google Sheets

Format Phone numbers in Google Sheets

Formatting phone numbers in Google Sheets refers to how they would appear in the cells. Unformatted phone numbers wouldn’t look any different than just some digits written together, without any dashes, slashes or spaces to indicate the digit distribution in a phone number. You could input phone numbers by putting the dashes in between the […]