Buzz
This article introduces you to the GAMMA function, one of the key statistical functions highly favored in Excel.
Description: The function returns the value of the gamma function. Supported in Excel 2013 and later versions.
Syntax: GAMMA(number)
In this context:
- number: The value for calculating the gamma function.
- The function is computed using the equation:
The gamma function equation is given as follows:
- If the number is a negative integer or equals 0 -> the function returns an error value #NUM!
- If the value of number is invalid -> the function returns an error value #VALUE!
Example:
Find the GAMMA function values for the data table below:
- In the cell where you want to calculate, enter the formula : =GAMMA(C6)
- Similarly, copy the formula for the remaining values to get the results:
- If the number value is a negative integer or equals to 0 -> the function returns an error value #NUM!
- If the number value is not a numeric value -> the function returns an error value #VALUE!
Here is a guide and some specific examples when using the GAMMA function in Excel.
Wishing you all success!
