GAMMA function - The function returns the gamma function value in Excel

The following article introduces you to the GAMMA function - one of the functions in the statistical function group is very popular in Excel.

GAMMA function - The function returns the gamma function value in Excel Picture 1

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:

GAMMA function - The function returns the gamma function value in Excel Picture 2 u

- In the cell to calculate enter the formula : = GAMMA (C6)

GAMMA function - The function returns the gamma function value in Excel Picture 3

- Similarly copying the formula for the remaining values ​​results:

GAMMA function - The function returns the gamma function value in Excel Picture 4

- Where the number value is a negative integer or equal to 0 -> the function returns the #NUM! Error value

GAMMA function - The function returns the gamma function value in Excel Picture 5

- Where the number value is not a numerical value -> the function returns the error value #VALUE!

GAMMA function - The function returns the gamma function value in Excel Picture 6

Above are instructions and some specific examples when using the GAMMA function in Excel.

Good luck!