Excel GAMMALN function
The GAMMALN function returns the natural logarithm of the gamma function, Γ(n).
GAMMALN Function VS. GAMMALN.PRECISE Function
Starting from Excel 2010, the GAMMALN function has been replaced by the GAMMALN.PRECISE function. Although they can both be used to calculate the natural logarithm of the gamma function, the GAMMALN.PRECISE function is more recommended for future use, as it 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 apply the GAMMALN 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: