# Documentation/Calc Functions/GAMMALN.PRECISE

Jump to navigation Jump to search

GAMMALN.PRECISE

## Category:

Statistical Analysis

## Summary:

Returns the natural logarithm of a gamma function value. The natural logarithm of the gamma function grows much more slowly than the gamma function and it is often more convenient to add and subtract logs instead of multiplying and dividing very large values.

## Syntax:

GAMMALN.PRECISE(Number)

## Returns:

Returns a real number which is the same as LN(GAMMA(N)) where N is the Number.

## Arguments:

Number is a real number or a reference to the cell containing that number for which the Gamma function value is to be calculated.

• If Number is a less than equal to zero, then the function returns an error value.

## Additional details:

• The formula for the GAMMALN.PRECISE is:

where N is the Number

• For more details on the natural logarithm of the Gamma function, visit Wikipedia

## Examples:

Formula Description Returns
=GAMMALN.PRECISE(2) The function calculates the natural logarithm of the gamma function value of 2 0
=GAMMALN.PRECISE(10) The function calculates the natural logarithm of the gamma function value of 10 12.8018274800815
=GAMMALN.PRECISE(2.8) The function calculates the natural logarithm of the gamma function value of 2.8 0.516702791987746
=GAMMALN.PRECISE(-2.8) The function returns an error for negative values of Number. Err:502
=GAMMALN.PRECISE(0) The function returns an error for 0 value of Number. Err:502

None

GAMMALN.PRECISE