The GAMMA function returns the Gamma function evaluated at the specified value.

Parts of a GAMMA function

GAMMA(number)

PartDescription
numberThe input to the Gamma function. The natural logarithm of Gamma (number) will be returned. The number must be positive.

Sample formulas

GAMMA(A1:A10)

GAMMA(1, 2, 3, 4)

GAMMA(B1:B5, 10)

Notes

GAMMA is used for certain types of analysis or as a component to other functions and is rarely used by itself.

Examples

AB
1Result
211.6317284
32
  • GAMMALN: Returns the logarithm of a specified Gamma function, base e (Euler’s number).