FACT

FACT(number)

Returns the factorial of a positive whole number.

number

The number you want the factorial of.

REMARKS

* The factorial of a number is equal to 1*2*3* ... "number".
* n! = n*(n-1)*(n-2)...(2)(1)
* The factorial of 0 is 1.
* If "number" < 0, then #NUM! is returned.
* If "number" is not an integer, it is truncated.
* If "number" is not numeric, then #VALUE! is returned.
* You can use the COMBIN function to return the number of combinations for a given number of items (with repetition).
* You can use the FACTDOUBLE function to return the double factorial of a positive whole number.
* You can use the GAMMA function to return the gamma function value.
* You can use the MULTINOMIAL function to return the number of permutations for a given number of items (with duplicates).
* For the Microsoft documentation refer to support.microsoft.com

	A	B
1	=FACT(0) = 1	= 0! = 1
2	=FACT(1) = 1	= 1! = 1
3	=FACT(2) = 2	= 2! = 2*1
4	=FACT(3) = 6	= 3! = 321
5	=FACT(4) = 24	= 4! = 432*1
6	=FACT(5) = 120	= 5! = 54321
7	=FACT(6) = 720	= 6! = 65432*1
8	=FACT(7) = 5040	= 7! = 7654321
9	=FACT(4.1) = 24
10	=FACT(4.999) = 24
11	=FACT(-1) = #NUM!

1 - What is the factorial of 0.
2 - What is the factorial of 1.
3 - What is the factorial of 2.
4 - What is the factorial of 3.
5 - What is the factorial of 4.
6 - What is the factorial of 5.
7 - What is the factorial of 6.
8 - What is the factorial of 7.
9 - What is the factorial of 4.1. This gets truncated to 4.
10 - What is the factorial of 4.999. This gets truncated to 4.
11 - What is the factorial of -1.