Returns the inverse of the Gamma cumulative distribution GAMMADIST. This function allows you to search for variables with different distribution.
GAMMA.INV(Number; Alpha; Beta)
Number is the probability value for which the inverse Gamma distribution is to be calculated.
Alpha is the parameter Alpha of the Gamma distribution.
Beta is the parameter Beta of the Gamma distribution.
This function is identical to GAMMAINV and was introduced for interoperability with other office suites.
=GAMMA.INV(0.8;1;1) yields 1.61.