WorksheetFunction.GammaLn Method
| Excel Developer Reference |
Returns the natural logarithm of the gamma function, Γ(x).
Syntax
expression.GammaLn(Arg1)
expression A variable that represents a WorksheetFunction object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Arg1 | Required | Double | X - the value for which you want to calculate GAMMALN. |
Return Value
Double
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:
.gif "Equation")
where:
.gif "Equation")
See Also