FACT(number)

Returns the factorial of a number.

numberThe number you want the factorial of.

Remarks

* The factorial of a number is equal to 1*2*3* to * "number".
* 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.
* The factorial of 1 is 0.
* For the Microsoft documentation refer to support.office.com

 AB
1=FACT(1) = 1=1 = 1
2=FACT(2) = 2=2*1 = 2
3=FACT(3) = 6=3*2*1 = 6
4=FACT(5) = 120=5*4*3*2*1 = 120
5=FACT(6) = 720 
6=FACT(0) = 1 
7=FACT(1.1) = 1 
8=FACT(1.9) = 1 
9=FACT(2.1) = 2 
10=FACT(2.9999) = 2 
11=FACT(3.1) = 6 
12=FACT(-1) = #NUM! 
13=FACT("some text") = #VALUE! 


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top