Excel like a finance pro.
← The libraryPractice · 2 questions →
Compatibility function
BETADIST
Returns the cumulative beta distribution; replaced by BETA.DIST.
Rarely usedDifficulty 1500 · AdvancedUsage rank #464 of 520
When to use it
The cumulative beta distribution. Replaced by BETA.DIST, which adds a cumulative flag.
The shape of it
- Syntax
=BETADIST(x, alpha, beta, [A], [B])
Worked examples
Symmetric
=BETADIST(0.5,2,2) → 0.5
Symmetric case.
Cumulative
=BETADIST(0.25,2,3) → 0.26171875
Same as BETA.DIST with TRUE.
Rescaled
=BETADIST(2,8,10,1,3) → 0.6854706
Rescaled to the range 1 to 3.
Worth knowing
- BETA.DIST(x,alpha,beta,TRUE,A,B) is the modern equivalent.
- No density option; that needs BETA.DIST with FALSE.
- Still calculates in every version.
Where it goes wrong
- #NUM! for x outside A to B or non-positive parameters.
- Flagged by the Compatibility Checker.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.