Skip to main content

GAMMALN

Returns the logarithm of a specified Gamma function, base e (Euler's number).

Sample Usage​

GAMMALN(4)

GAMMALN(A2)

Syntax​

GAMMALN(value)

  • value - The input to the Gamma function. The natural logarithm of Gamma (value) will be returned.
    • value must be positive.

Notes​

  • GAMMALN is used for certain types of analysis or as a component to other functions and is rarely used by itself.

See Also​

SQRTPI: Returns the positive square root of the product of Pi and the given positive number.

SQRT: Returns the positive square root of a positive number.

POWER: Returns a number raised to a power.

LOG10: Returns the logarithm of a number, base 10.

LOG: Returns the logarithm of a number given a base.

LN: Returns the logarithm of a number, base e (Euler's number).

EXP: Returns Euler's number, e (~2.718) raised to a power.

Examples​