Returns the factorial of a number. Learn more
FACT is a function in Google Sheets that returns the factorial of a given value. The factorial of a number is the product of all positive integers up to and including that number.
For example, the factorial of 5 is 5 x 4 x 3 x 2 x 1, which equals 120.
The FACT function takes one argument, which is the value for which you want to calculate the factorial. The value must be a non-negative integer.
Here's an example:
Let's say you want to find the factorial of 7. To use the FACT function in Google Sheets, you would write:
=FACT(7)
This function will return the factorial of 7, which is 5040.