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:
where:
Example
|
Formula |
Description (Result) |
|---|---|
|
=GAMMALN(4) |
Natural logarithm of the gamma function at 4 (1.791759) |
