How to use GAMMA Function in Excel

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

Syntax:= GAMMA(number)

The GAMMA function syntax has the following arguments:

  • Number    Required. Returns a number.

Example: Let’s look at some Excel GAMMA function examples and explore how to use the GAMMA function as a worksheet function in Microsoft Excel:

Syntax:  =GAMMA(A2)

Result: 9.513507699

Based on the Excel spreadsheet above, the following GAMMA examples would return:

Syntax: =GAMMA(A3)
Result: 1

Syntax: =GAMMA(A4)
Result: 0.886226925

Syntax: =GAMMA(A5)
Result: 52.34277778

Syntax: =GAMMA(A6)
Result: 1.329340388

Syntax: =GAMMA(A7)
Result: 0.267866129

Syntax: =GAMMA(A8)
Result: #NUM!

Syntax: =GAMMA(A9)
Result: #NUM!

Syntax: =GAMMA(A10)
Result: #NUM!


  • Г(N+1) = N * Г(N)
  • If Number is a negative integer or 0, GAMMA returns the #NUM! error value.
  • If Number contains characters that are not valid, GAMMA returns the #VALUE! error value.

  • The Gamma Function, Γ(n), is calculated by the following formula:


Add a Comment

Your email address will not be published. Required fields are marked *