Returns the natural logarithm of the gamma function, Γ(x).
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
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)결과: 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.