Description

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

Sample Usage

Syntax

GAMMALN.PRECISE(x)

The GAMMALN.PRECISE function syntax has the following arguments:

  • X    Required. The value for which you want to calculate GAMMALN.PRECISE.

Remarks

  • If x is nonnumeric, GAMMALN.PRECISE returns the #VALUE! error value.

  • If x ≤ 0, GAMMALN.PRECISE returns the #NUM! error value.

  • The number e raised to the GAMMALN.PRECISE(i) power, where i is an integer, returns the same result as (i - 1)!.

  • GAMMALN.PRECISE is calculated as follows:

    GAMMALN.PRECISE = LN(Γ(x))

    where:

    Equation

In order to use the GAMMALN.PRECISE formula, start with your edited Excellentable:


  


Then type in the GAMMALN.PRECISE formula in the area you would like to display the outcome:



By adding the values you would like to calculate the GAMMALN.PRECISE formula for, Excellentable will generate the outcome:



Error.

User does not have sufficient privileges to access this Content
Learn More