Returns the natural logarithm of the gamma function, Γ(x).
Esta función funciona igual en Google Sheets que en Excel: misma sintaxis y mismos argumentos.
GAMMALN(x)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)Resultado: 1.791759
Calculates the natural logarithm of (4-1)!, which is ln(6).
If x is less than or equal to 0, GAMMALN returns the #NUM! error value.