The following article introduces you to the GAMMA function - one of the functions in the statistical function group is very popular in Excel.
Description: The function returns the gamma function value . Support functions from Excel 2013 onwards.
Syntax: GAMMA (number )
Inside:
- number: The value you want to calculate the gamma function value .
Attention:
- Function of calculation using equation:
[Gamma left (N right) = intlimits_0 ^ infty {{t ^ {N - 1}} {e ^ {- t}} dt}]
- If number is a negative integer or equal to 0 -> the function returns the #NUM! Error value .
- If the number value is not valid -> the function returns the error value #VALUE!
For example:
Find the value of the GAMMA function of the values in the data table below:
- In the cell to calculate enter the formula : = GAMMA (C6)
- Similarly copying the formula for the remaining values results:
- Where the number value is a negative integer or equal to 0 -> the function returns the #NUM! Error value
- Where the number value is not a numerical value -> the function returns the error value #VALUE!
Above are instructions and some specific examples when using the GAMMA function in Excel.
Good luck!