The Excel GAMMA Function
Gamma Function
The Gamma Function, Γ(n), is calculated by the following formula:
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:
|
Results:
|
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. |