The GAMMA function returns the value of the Gamma function, \Gamma(n), for a specified number, n.

  • This function was introduced in Excel 2013 and so is not available in earlier versions.




Argument Description
number A positive real number


  A B C
1 Formula Result Notes
2 =GAMMA(2.25) 1.133003 Returns the gamma function value of 2.25
3 =GAMMA(-3.5) 0.270088 Returns the gamma function value of -3.5

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if the supplied number argument is not recognized as a numeric value
#NUM! Occurs if the supplied number argument is ≤ 0

The Gamma function, \Gamma(n) is calculated using the formula:    

    \[    \Gamma(n) = \int_0^{\infty} t^{n-1}e^{-t} \ dt    \]

See Wikipedia for more information on Gamma function.