[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

GAMMALN

Syntax:

GAMMALN ( x )

Description: Computes the natural logarithm of the gamma function.

Mathematical Formula:

where:

Arguments:

Name

Type

Description

x

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 ≤ 0, #NUM! is returned.

[Example:

GAMMALN(4.5) results in 2.453736571


end example]