Microsoft® Excel® 2010 Formulas & Functions Inside Out

GAMMALN()

Syntax. GAMMALN(x)

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

Arguments

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

Note

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 ...