Functions
GAMMALN
Natural logarithm of the gamma function
Try it
When to use it
When would I use GAMMALN in a spreadsheet?
Use GAMMALN when computing the natural logarithm of the gamma function for statistical probability models such as Poisson or chi-squared distributions.
Used in
Syntax
GAMMALN(x)Examples
=GAMMALN(4) // => 1.791759469228055
=GAMMALN(1) // => 0
=GAMMALN(0.5) // => 0.5723649429247