GAMMA.INV Function
Returns the value at a given probability of a gamma distribution.
Category
Statistical
Available in
Excel 2010+, Microsoft 365
Returns
A number
Want to practice GAMMA.INV in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
GAMMA.INV is the reverse of GAMMA.DIST: give it a probability and it returns the value with that share of the distribution below it.
Syntax
=GAMMA.INV(probability, alpha, beta) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| probability | Yes | The share below the value, from 0 to 1. |
| alpha | Yes | The shape; must be greater than 0. |
| beta | Yes | The scale; must be greater than 0. |
Examples
Example 1 — How long to quote for three repairs?
Three repairs averaging 2 hours each (alpha 3, beta 2).
B5fx=GAMMA.INV(0.9,B2,B3)
| A | B | |
|---|---|---|
| 1 | Measure | Value |
| 2 | Jobs (alpha) | 3 |
| 3 | Hours per job (beta) | 2 |
| 4 | Median total | 5.35 |
| 5 | 90% sure | 10.64 |
=GAMMA.INV(0.9,B2,B3) Explain
Quote about 10.6 hours to be 90% sure of finishing; half the time it takes under 5.35.
Common mistakes
- #NUM! probability is outside 0–1, or alpha or beta is 0 or negative.
Notes
- Related functions: GAMMA.DIST, CHISQ.INV.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.