Related Function:

The GAMMA.INV function returns the inverse of the gamma cumulative distribution, e.g. if p = GAMMA.DIST(x, … ), then GAMMA.INV(p, … ) = x.

  • This function was introduced in Excel 2010 and so is not available in earlier versions.
  • The GAMMA.INV function replaces the GAMMAINV function included in earlier versions of Excel.

Syntax

=GAMMA.INV(probability,alpha,beta)

Arguments

Argument Description
probability The probability value, between 0 and 1, for which you want to calculate the inverse of the Gamma distribution
alpha A parameter to the distribution
beta A parameter to the distribution. If beta = 1, GAMMA.INV returns the Standard Gamma distribution

Examples

  A B C D
1 Data Description    
2 0.051398 Probability associated with the gamma distribution
3 8 Alpha parameter to the distribution
4 3 Beta parameter to the distribution
5        
6 Forumla Result Notes
  =GAMMA.INV(A2,A3,A4) 12.01331 Inverse of the gamma cumulative distribution for the probability, alpha, and beta arguments in A2, A3, and A4

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if any of the supplied arguments are non-numeric
#NUM! Occurs if either:

  the supplied probability value is < 0 or ≥ 1
  the supplied alpha ≤ 0 or the supplied beta ≤ 0
#N/A Occurs if Excel fails to converge to a solution after 64 iterations