The FACT function in Google Sheets is a powerful mathematical tool used to compute the factorial of a specified number. Factorials are foundational in various fields, particularly in mathematics and statistics, where they are employed in permutations, combinations, and calculus. This function simplifies the process of calculating these values, allowing users to perform complex calculations with ease.
Syntax
FACT(number)
- number: The non-negative integer for which the factorial is to be calculated. This value must be >= 0, as factorials for negative integers do not exist.
Example #1
FACT(5)
Calculates the factorial of 5, resulting in 120 (5! = 5 × 4 × 3 × 2 × 1).
Example #2
FACT(0)
Calculates the factorial of 0, resulting in 1, as 0! is defined to be 1.
Example #3
FACT(7)
Calculates the factorial of 7, resulting in 5040 (7! = 7 × 6 × 5 × 4 × 3 × 2 × 1).
Error handling
- NUM! Error occurs when the input is a negative number, as factorials are not defined for negative integers.
- VALUE! Error occurs if the input is non-numeric, indicating that the argument must be a number.