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 –
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!