Statistical - GAMMALN Function

Description

The GAMMALN function returns the natural logarithm of the gamma function, $\Gamma \left ( x \right )$.

Syntax

GAMMALN(x)

Arguments

Notes

• GAMMALN is calculated as follows −

  $$GAMMALN=LN\left ( \Gamma \left ( x \right ) \right )$$

  Where,

  $$f\left ( x \right )=\left\{\begin{matrix} 0 & if \: x< 0 & \\ x & \quad\quad if \: 0 \:\leq x \leq 1 & \\ 1 & if \:x> 1& \end{matrix}\right.$$

• The number e raised to the GAMMALN(i) power, where i is an integer, returns the same result as (i - 1)!

• If x is nonnumeric, GAMMALN returns the #VALUE! error value.

• If x ≥ 0, GAMMALN returns the #NUM! error value.

Applicability

Excel 2007, Excel 2010, Excel 2013, Excel 2016

Example