BETA.INV Function
Returns the value at a given probability of a beta distribution.
Category
Statistical
Available in
Excel 2010+, Microsoft 365
Returns
A number
Want to practice BETA.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
BETA.INV is the reverse of BETA.DIST: give it a probability and it returns the value with that share below it, between 0 and 1 or your own bounds A and B.
Syntax
=BETA.INV(probability, alpha, beta, [A], [B])
Arguments
| Argument | Required? | What it does |
|---|---|---|
| probability | Yes | The share below the value, between 0 and 1. |
| alpha | Yes | Shape parameter; must be greater than 0. |
| beta | Yes | Shape parameter; must be greater than 0. |
| A | No | Lower bound (0 if left out). |
| B | No | Upper bound (1 if left out). |
Examples
Example 1 — A task estimate you can commit to
The same 4–10 day task with alpha 2 and beta 3.
B7fx=BETA.INV(0.8,B2,B3,B4,B5)
| A | B | |
|---|---|---|
| 1 | Measure | Value |
| 2 | alpha | 2 |
| 3 | beta | 3 |
| 4 | Shortest (A) | 4 |
| 5 | Longest (B) | 10 |
| 6 | Median | 6.31 |
| 7 | 80% sure | 7.49 |
=BETA.INV(0.8,B2,B3,B4,B5) Explain
Commit to about 7.5 days to be 80% confident.
Common mistakes
- #NUM! probability is 0 or less or more than 1, alpha or beta is 0 or negative, or A equals B.
Notes
- Related functions: BETA.DIST.

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.