Changes

Jump to navigation Jump to search
Line 10: Line 10:  
*For complex numbers with a positive real part, it is defined via a convergent improper integral:
 
*For complex numbers with a positive real part, it is defined via a convergent improper integral:
 
<math>\Gamma (z) = \int\limits_{0}^{\infty} x^{z-1} e^{-x} dx </math>
 
<math>\Gamma (z) = \int\limits_{0}^{\infty} x^{z-1} e^{-x} dx </math>
 +
*This function will return the result as NaN when the given number as negative or Non numeric.
 +
 +
 +
==Examples==
 +
#GAMMAFUNCTION(2) = 1.0000026676984093
 +
#GAMMAFUNCTION(45.3) = 8.308990531109891e+54
 +
#GAMMAFUNCTION(-3) = NaN
 +
 +
==See Also==
 +
*[[Manuals/calci/SUM | SUM]]
 +
*[[Manuals/calci/AVERAGE  | AVERAGE ]]
 +
*[[Manuals/calci/AVERAGEA  | AVERAGEA ]]
writer
6,694

edits

Navigation menu