Syntax. GAMMALN(x)

Definition. This function returns the natural logarithm of the gamma function (Γ(x)).


  • x (required). The value for which you want to calculate GAMMALN()


If x isn’t a numeric expression, the GAMMALN() function returns the #VALUE! error. If x is less than or equal to 0, the function returns the #NUM! error.

The number e raised to the GAMMALN(i) power, where i is an integer, returns the same result as (i – 1).

Background. The GAMMALN() function returns the natural logarithm of the gamma function.

See Also

You will find more information about gamma distributions in the description of GAMMA.DIST().

The logarithm of a number is the exponent by which a fixed number, the base, has to be raised to produce that number. The ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.