GAMMA function

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

Parts of a GAMMA function 


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

Sample formulas 


GAMMA(1, 2, 3, 4)

GAMMA(B1:B5, 10)


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


  A B
1 Result Formula
2 11.6317284 =GAMMA(4.5)
3 2 =GAMMA(3)

Related functions 

  • GAMMALN: Returns the logarithm of a specified Gamma function, base e (Euler's number).
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Clear search
Close search
Google apps
Main menu