This function returns the natural logarithm of the Gamma function, G(x).

Syntax

GAMMALN.PRECISE(value)

Arguments

The argument is any numeric value.

Remarks

This function is calculated as the natural logarithm (LN) of the Gamma function. If value is nonnumeric, the function returns the #VALUE! error value. If x ≤ 0, this function returns the #NUM! error value.

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

GAMMALN.PRECISE(A4)

GAMMALN.PRECISE(R4C1)

GAMMALN.PRECISE(12) gives the result 17.502307845873887