The Gamma function is widely used in science, business, and engineering. It is useful for the variables which are always positive. For example, the GAMMA function in Excel can be very helpful to find the shear strength in engineering calculation.
The above image is an overview of the GAMMA function. From this article, I hope you will get the complete idea to use the GAMMA function in Excel.
Download Practice Workbook
You can download the free Excel template from here and practice on your own.
What Is the Gamma Function?
Actually, the Gamma function is the generalization of the factorial function for nonintegral values which was introduced by Leonhard Euler- a Swiss mathematician.
If n is a positive whole number then the factorial (n!) will be defined by-
n!=1×2×3×4×…×(n-1)×n
For example, 4!=4×3×2×1=24. But this formula is invalid if n is not an integer.
The gamma function is defined for any real number z>0(whether or not z is a whole number) as follows.
The table given below shows the Gamma value for the range 0.0083 ≤ n ≤ 5.
The following graph shows the Gamma Function value, Γ(n) for 0.0083 ≤ n ≤ 5.
Introduction to Excel GAMMA Function
The GAMMA function is categorized under the Statistical function in Excel.
Purpose:
The GAMMA function is used to find the Gamma function value.
Syntax:
=GAMMA(number)
Arguments:
Argument | Required/Optional | Explanation |
---|---|---|
x | Required | A positive real number. |
Return Parameter:
The Gamma function returns a numeric value.
Available in:
It is new in Excel 2013 and so is not available in the earlier versions of Excel.
An Example of Excel GAMMA Function
Now we’ll see an example of how to use the GAMMA function in Excel. It’s quite simple.
For that, I have made a dataset of some random positive real numbers.
Steps:
⏩ Activate Cell C5.
⏩ Then type the following formula in it-
=GAMMA(B5)
⏩ Later, just press the Enter button.
And you will find output 1 for the value 2.
⏩ To copy the formula for the other cells just drag down the Fill Handle icon by using your mouse over the cells.
Here’s the all output for the values.
Errors While Using the GAMMA Function in Excel
You will get errors for some specific values. Because the GAMMA function can’t deal with that kind of value. To show that I have rearranged the dataset. I have inserted 0, negative integer, and non-numeric values in the dataset.
At first, let’s find the output-
Steps:
⏩ Write the following formula in Cell C5–
=GAMMA(B5)
⏩ Then press the Enter button and use the Fill Handle tool to get all the outputs.
Then you will spot the output like the image below. Here you will notice that we’ll get #NUM error for 0 and negative integers and #VALUE error for non-numeric characters.
Things to Remember
The input number should be numeric and greater than 0. Otherwise, the GAMMA function will return #NUM! and #VALUE! error.
Conclusion
I hope all of the methods described above will be good enough to use the GAMMA function. Feel free to ask any question in the comment section and please give me feedback.