WorksheetFunction.GammaLn_Precise Method (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

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: awfgamm1_ZA06051143where: awfgamm2_ZA06051144

Show: