Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Maths and Trigonometry > FACT
 

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*...* "number".
     
  		• If "number" < 0, then #NUM! is returned.
     
  		• The factorial of 1 is 0.

     EXAMPLES
     
     AB
    1=FACT(3) = 6=3*2*1 = 6
    2=FACT(5) = 120=5*4*3*2*1 = 120
    3=FACT(1.9) = 1 
    4=FACT(2.1) = 2 
    5=FACT(3.1) = 6 
    6=FACT(0) = 1 
    7=FACT(-1) = #NUM! 
    8=FACT("some text") = #VALUE! 
    		 
     Functions - F | Index - F | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top