Goal: Calculate the Factorial (n!).
FACT multiplies a number by every integer below it, down to 1. (e.g., 5! = 5 × 4 × 3 × 2 × 1).
Ready...
💻 Formula Structure
=FACT(number)
- Number: The non-negative integer to calculate.
- Note: Numbers containing decimals are truncated.
-- Calculate Factorial
=FACT( 5 )
⚠️ Mathematical Rules
0! = 1
The factorial of 0 is defined as 1 (representing an empty product), not 0. This is a common math trick question!
📈 Rapid Growth
Factorials grow incredibly fast. 10! is 3.6 million. Excel cannot handle factorials larger than 170! (it returns #NUM!).