Find the factorial of a number
=FACT(number)| Parameter | Description |
|---|---|
number |
The number to get the factorial of. |
The Excel FACT function returns the factorial of a given number. A factorial is the product of a whole number and all the positive whole numbers below
3! = 3 × 2 × 1 = 6Here are the factorials for four, five, and six:
4! = 4 × 3 × 2 × 1 = 24
5! = 5 × 4 × 3 × 2 × 1 = 120
6! = 6 × 5 × 4 × 3 × 2 × 1 = 720=FACT(3) // returns 6
=FACT(4) // returns 24
=FACT(5) // returns 120
=FACT(6) // returns 720If number is not an integer it will be truncated to an integer:
=FACT(3.2) // returns 6When number is zero, FACT returns 1:
=FACT(0) // returns 1If number is negative, FACT returns the #NUM! error:
=FACT(-3) // returns #NUM!