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.