GAMMADIST function
GAMMADIST returns a gamma-distribution value, modeling positive, right-skewed quantities such as waiting times or claim sizes. It still works, but GAMMA.DIST supersedes it for new workbooks.
Example
Read it as a sentence: find the cumulative gamma distribution at D1 (which is empty, so counted as 0) with shape 2 and scale 2.
Excel shows 0
D
1
Data
Syntax
GAMMADIST(x, alpha, beta, cumulative)
-
x(required) - Value to evaluate, 0 or more.
-
alpha(required) - Shape parameter.
-
beta(required) - Scale parameter.
-
cumulative(required) - TRUE for cumulative probability, FALSE for density.
Returns: A gamma-distribution value.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=GAMMADIST(4,2,2,TRUE) | 0.59399415 | Working example |
=GAMMADIST(4,2,2,FALSE) | 0.135335283 | Other cumulative flag |
=GAMMADIST(4,2,2,0) | 0.135335283 | Cumulative as 0 |
=GAMMADIST("4",2,2,TRUE) | 0.59399415 | Text-number in first arg |
=GAMMADIST({4,4},2,2,TRUE) | 0.59399415 | Array in first arg (lifts, spills) |
=GAMMADIST(Data!D1,2,2,TRUE) | 0 | Blank cell as first arg |
=GAMMADIST("abc",2,2,TRUE) | #VALUE! | Non-numeric text in first arg |
=GAMMADIST(NA(),2,2,TRUE) | #N/A | Error in first arg |
The Data sheet these formulas read
A cell that starts with = holds that formula.
D
1
Data
Watch out for
- Superseded by GAMMA.DIST; use that in new workbooks.
- beta is a scale (mean = alpha*beta), not a rate.
Where it works
- Excel
- GAMMADIST is in every version of Excel from 2007 on. Compatibility function: still works in every version, but newer replacements exist.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Compatibility functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .