GAMMALN function

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

Syntax

GAMMALN(x)

X     is the value for which you want to calculate GAMMALN.

Remarks

  • If x is nonnumeric, GAMMALN returns the #VALUE! error value.

  • If x ≤ 0, GAMMALN returns the #NUM! error value.

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

  • GAMMALN is calculated as follows:

    Equation

    where:

    Equation

Example

Formula

Description (Result)

=GAMMALN(4)

Natural logarithm of the gamma function at 4 (1.791759)

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×