next up previous contents index
Next: GMEAN, GEOMEAN Up: A. Function Reference Previous: FVSCHEDULE   Contents   Index


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 $(N1)!$ (N1 factorial). The function is given by:

\begin{displaymath}
\int_0^\infty e^{-x} x^{n-1} dx
\end{displaymath}

Examples:

GAMMA(5) = 24

GAMMA(1.59) = 0.89243

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

Excel function: N/A


next up previous contents index
Next: GMEAN, GEOMEAN Up: A. Function Reference Previous: FVSCHEDULE   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003