Returns the natural logarithm of the gamma function, Γ(x).
Składnia
GAMMALN(x)Argumenty
xwymagane
The value for which you want to calculate the natural logarithm of the gamma function.
The GAMMALN function calculates the natural logarithm of the absolute value of the gamma function, Γ(x). It is commonly used in statistical analysis to handle very large numbers that would otherwise cause overflow errors.
=GAMMALN(4)→1.791759Calculates the natural logarithm of (4-1)!, which is ln(6).
Select a cell
Click on the cell where you want to display the result.
Enter the formula
Type =GAMMALN(x) and replace x with the desired number or cell reference.
If x is less than or equal to 0, GAMMALN returns the #NUM! error value.