Excel GAMMALN.PRECISE function
The GAMMALN.PECISE function returns the natural logarithm of the gamma function, Γ(n).
Note: The GAMMALN.PRECISE function is new in Excel 2010 and is only available in Excel 2010 and later versions.
GAMMALN.PRECISE Function VS. GAMMALN Function
Starting from Excel 2010, the GAMMALN.PRECISE function was released to replace the GAMMALN function. Although they can both be used to calculate the natural logarithm of the gamma function, the GAMMALN.PRECISE function works more accurately.
It returns a numeric value.
To calculate the natural logarithm of the gamma function of the given values in the table below, you can also apply the GAMMALN.PRECISE function as follows.
Select a cell (such as C6 in this case), enter the formula below and press the Enter key to get the first result. Select this formula cell and drag its AutoFill Handle down to get the rest of the results.
Notes: The argument in the formula above is supplied as a cell reference. You can directly type the value in the formula. Here the formula in C6 can be changed to: