Description Computes the logarithm of the gamma function.
Syntax GAMMALN (number)
| Argument | Description |
|---|---|
| number | A positive number. The function will return the #VALUE! error if number is nonnumeric and the #NUM! error if number is negative. |
Remarks The gamma function is a generalization of the factorial function. For positive integers, the factorial of n is the same as the gamma function of n + 1. The gamma function is a building block used in worksheet functions like COMBIN and PERMUT.
The inverse of the GAMMALN function is the EXP function with the GAMMALN function as the argument.
Equation
where z is the argument.
As noted above, when z is an integer, the equation can be simplified to 
.
Examples This function returns 3.17805383
