GAMMA

Syntax: GAMMA(X)

X = a numeric value

GAMMA returns the value of the Euler's gamma function evaluated for values of $X > 0$, and less than or equal to approximately 171 (less on a few computers with limited mathematics capabilities). Gamma is a continuous function whose value for integer arguments N is $(N­1)!$ (N1 factorial). The function is given by:

$$\int_0^\infty e^{-x} x^{n-1} dx$$

Examples:

GAMMA(5) = 24

GAMMA(1.59) = 0.89243

GAMMA(L38) = Error - GAMMA, floating exception, where L8 = 175

Excel function: N/A