Returns the natural logarithm of the gamma function, Γ(x).
この関数は Google スプレッドシートでも 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.