Syntax. GAMMA.INV(probability,alpha,beta)

Definition. This function returns the quantile of the gamma distribution. If p = GAMMA.DIST(x,...) then GAMMA.INV(p,...) = x.

Use this function to examine a variable whose distribution may be skewed.


  • probability (required). A probability associated with the gamma distribution.

  • alpha (required). A parameter of the distribution.

  • beta (required). A parameter of the distribution. If beta = 1, GAMMA.INV() returns the standard gamma distribution.


If one of the arguments isn’t a numeric expression, the GAMMA.INV() function returns the #VALUE! error.

If probability is less than 0 or greater than 1, the GAMMA.INV() function returns the #NUM! error.

If alpha or beta is less than or equal ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.