The Excel GAMMA Function

Related Functions:
GAMMA.DIST
GAMMALN.PRECISE
Gamma Function

The Gamma Function, Γ(n), is calculated by the following formula: The function is explained in detail on the Wikipedia Gamma Function page.

Function Description

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

Note: The Gamma function is new in Excel 2013 and so is not available in earlier versions of Excel.

The syntax of the function is:

GAMMA( number )

where the number argument is a positive real number.

Gamma Function Examples Gamma Function Γ(n) for 0.0083 ≤ n ≤ 6

The above chart on the right shows the Gamma Function, Γ(n), for 0.0083 ≤ n ≤ 6.

In the spreadsheets below, the Excel Gamma function is used to evaluate this function for four different values of n.

Formulas:
A
1=GAMMA( 0.1 )
2=GAMMA( 1 )
3=GAMMA( 1.5 )
4=GAMMA( 5.5 )
Results:
A
19.513507699
21
30.886226925
452.34277778

For further examples of the Excel Gamma function, see the Microsoft Office website.

Gamma Function Errors

If you get an error from the Excel Gamma Function, this is likely to be one of the following:

Common Errors
 #NUM! - Occurs if the supplied number argument is ≤ 0. #VALUE! - Occurs if the supplied number argument is non-numeric.