The GAMMALN.PRECISE function returns the natural logarithm of the gamma function, .
- This function was introduced in Excel 2010 and so is not available in earlier versions.
|x||The value for which you want to calculate GAMMALN.PRECISE|
|2||=GAMMALN.PRECISE(4)||1.791759||Natural logarithm of the gamma function at 4|
|3||=GAMMALN.PRECISE(3.5)||1.200974||Natural logarithm of the gamma function at 3.5|
|4||=GAMMALN.PRECISE(1.5)||-0.12078||Natural logarithm of the gamma function at 1.5|
Common Function Error(s)
|Problem||What went wrong|
|#VALUE!||Occurs if the supplied value of x is non-numeric|
|#NUM!||Occurs if the supplied value of x is ≤ 0|
GAMMALN.PRECISE is calculated as: