Navigation:  Formula Reference > Spreadsheet Formula Functions > GAMMALN

 

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

Syntax

GAMMALN(value)

Arguments

The argument is any numeric value.

Remarks

This function is calculated as the natural logarithm (LN) of the Gamma function.

The equation for this function is:

where x is the value argument.

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

GAMMALN(A4)

GAMMALN(R4C1)

GAMMALN(12) gives the result 17.5023078459

 

See Also

GAMMADIST

GAMMAINV

LN