GAMMA

GAMMA(number)

Returns the gamma function value.

numberThe 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
* You can use the GAMMA.INV function to
* 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
* For the Google documentation refer to support.google.com

 AB
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) = 3*2*1
6=GAMMA(5) = 24 = FACT(4) = 4*3*2*1
7=GAMMA(6) = 120 = FACT(5) = 5*4*3*2*1
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.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top