# Documentation/Calc Functions/GAMMALN.PRECISE

Jump to navigation
Jump to search

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

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 |

## Related LibreOffice functions:

## ODF standard:

None

## Equivalent Excel functions:

GAMMALN.PRECISE