Related Functions:

The GAMMALN.PRECISE function returns the natural logarithm of the gamma function, \Gamma(n).

  • This function was introduced in Excel 2010 and so is not available in earlier versions.

Syntax

=GAMMALN.PRECISE(x)

Arguments

Argument Description
x The value for which you want to calculate GAMMALN.PRECISE

Examples

  A B C
1 Formula Result Notes
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:    

    \[    \begin{aligned} \text{GAMMALN.PRECISE} &= \ln(\Gamma(x))  \\\\ \text{where: } f(x) &= \left\{ \begin{aligned} 0 \ \ & \text{if } x < 0 \\ x \ \ & \text{if } 0 \leq x \leq 1 \\ 1 \ \ & \text{if } x > 1  \end{aligned} \end{aligned}    \]