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

Version Available

This function is available in Spread for Windows Forms 11.0 or later.

See Also

GAMMA