Expand Minimize

WorksheetFunction.GammaLn_Precise Method (Excel)

Returns the natural logarithm of the gamma function, Γ(x).

Version Added: Excel 2010

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

  • 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: Ff837383.awfgamm1_ZA06051143(en-us,office.14).gifwhere: Ff837383.awfgamm2_ZA06051144(en-us,office.14).gif

Show:
© 2014 Microsoft