GAMMA.INV

GAMMA.INV(probability, alpha, beta)

Returns the inverse of the cumulative probability function for a gamma distribution.

probability	The probability associated with the distribution.
alpha	The first parameter to the distribution.
beta	The second parameter to the distribution.

REMARKS

* For an illustrated example refer to the page under Distributions
* The gamma distribution is a continuous distribution
* 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 function
* This function was added in Excel 2010 to replace the GAMMAINV function.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A
1	=GAMMA.INV(0.068094, 9, 2) = 10.00
2	=GAMMA.INV(0.5, 4, 2) = 7.34
3	=GAMMA.INV(0.068, 4, 2) = 3.04
4	=GAMMA.INV(GAMMADIST(7, 5, 1, TRUE), 5, 1) = 7.00
5	=GAMMA.INV(GAMMADIST(0.5, 4, 2, TRUE), 4, 2) = 0.50
6	=GAMMA.INV(0.5, 4, 2) = 7.34
7	=GAMMA.INV(0.5, -9, 2) = #NUM!
8	=GAMMA.INV(-2, 9, 2) = #NUM!
9	=GAMMA.INV(-2, "some text", 2) = #VALUE!