Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Statistical > GAMMALN
 

GAMMALN(x)

 
 Returns the natural logarithm of the gamma function, G(x).

 xThe number you want the natural logarithm of.

 REMARKS
 
  		• If "x" is not numeric, then #VALUE! is returned.
     
  		• If "x" = 0, then #NUM! is returned.
     
  		• The number e raised to the GAMMALN(i) power, where i is an integer, returns the same result as (i - 1)!.

     EXAMPLES
     
     A
    1=GAMMALN(4) = 1.792
    2=GAMMALN(2.5) = 0
    3=EXP(GAMMALN(4)) = 6
    4=GAMMALN(-1) = #NUM!
    5=GAMMALN("some text") = #VALUE!
    		 
     Functions - G | Index - G | Office Online 

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