WorksheetFunction.GammaLn_Precise Method (Excel)
Returns the natural logarithm of the gamma function, Γ(x).
Version Information
Version Added: Excel 2010
Syntax
expression .GammaLn_Precise(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, the GammaLn_Precise method generates an error.
If x ≤ 0, the GammaLn_Precise method generates an error.
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 "Ff837383.awfgamm1_ZA06051143(en-us,office.14).gif")
where: .gif "Ff837383.awfgamm2_ZA06051144(en-us,office.14).gif")