[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
GAMMALN ( x )
Description: Computes the natural logarithm of the gamma function.
Mathematical Formula:
where:
Arguments:
Name |
Type |
Description |
number |
The value for which the gamma function is to be calculated. |
Return Type and Value: number – The natural logarithm of the gamma function.
However, if x ≤ 0, #NUM! is returned.
[Example:
GAMMALN(4.5) results in 2.453736571
end example]