GAMMALN.PRECISE

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:

  

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:

	A	B	C	D
1	GAMMALN.PRECISE Formula	Data	Value
2		4	1.791759469
3	GAMMALN.PRECISE Formula	6	4.787491743
4
5
6
7
8
9
10