GAMMA

GAMMA(number)

Returns the gamma function value.

number

The number

REMARKS

* If "number" <= 0, then #NUM is returned.
* You can use the COMBIN function to return the number of combinations for a given number of items (without repetition).
* You can use the FACT function to return the factorial of a positive whole number.
* You can use the GAMMA.DIST function to return the probability function OR the cumulative probability function for a gamma distribution.
* You can use the GAMMA.INV function to return the inverse of the cumulative probability function for a gamma distribution.
* You can use the GAMMALN function to return the natural logarithm of the gamma function.
* You can use the PI function to return the number PI (3.141592).
* You can use the SQRT function to return the positive square root of a number.
* This function was added in Excel 2013.
* For the Microsoft documentation refer to support.microsoft.com

	A	B
1	=GAMMA(0) = #NUM!
2	=GAMMA(1) = 1	= FACT(0)
3	=GAMMA(2) = 1	= FACT(1)
4	=GAMMA(3) = 2	= FACT(2) = 2*1
5	=GAMMA(4) = 6	= FACT(3) = 321
6	=GAMMA(5) = 24	= FACT(4) = 432*1
7	=GAMMA(6) = 120	= FACT(5) = 54321
8	=GAMMA(0.5) = 1.77245385090552	= SQRT(PI())

1 - What is the gamma of 0.
2 - What is the gamma of 1.
3 - What is the gamma of 2.
4 - What is the gamma of 3.