GAMMALN

GAMMALN(x)

Returns the natural logarithm of the gamma function.

x	The number you want the natural logarithm of.

REMARKS

* GAMMALN.PRECISE was added in Excel 2010 to replace this function.
* 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)!.
* You can use the GAMMA function to return the gamma function value.
* You can use the GAMMA.DIST function to return the probability function OR the cumulative probability function for a gamma distribution.
* You can use the GAMMA.INV function to return the inverse of the cumulative probability function for a gamma distribution.
* For the Microsoft documentation refer to support.microsoft.com

	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!