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.