January 21, 2022

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!

Note:

• Г(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: READ:  How to use LOGNORM.DIST Function in Excel 