# 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 FACTDOUBLE function to return the double factorial of a positive whole number.* You can use the GAMMA function* For the Microsoft documentation refer to support.microsoft.com* For the Google documentation refer to support.google.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! = 3*2*1 5 =FACT(4) = 24 = 4! = 4*3*2*1 6 =FACT(5) = 120 = 5! = 5*4*3*2*1 7 =FACT(6) = 720 = 6! = 6*5*4*3*2*1 8 =FACT(7) = 5040 = 7! = 7*6*5*4*3*2*1 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.