BINOMDIST Function in Excel: Syntax, Examples and Free Practice
BINOMDIST is an Excel Compatibility function. Legacy version of the binomial distribution — kept for compatibility with older files.
BINOMDIST syntax
Arguments
number_s: The number of successestrials: The number of independent trialsprobability_s: The probability of success on a single trialcumulative: TRUE for the cumulative distribution, FALSE for the probability mass
When to use BINOMDIST
BINOMDIST is kept mainly for opening older files built in earlier versions of Excel.
Practice BINOMDIST online, free
Open the live Excel-style spreadsheet and try BINOMDIST yourself. No Excel install or sign-up needed to start.
Practice BINOMDIST now →More Compatibility functions
- BETADIST
- CHIDIST
- CHIINV
- CHITEST
- CONFIDENCE
- COVAR
- CRITBINOM
- EXPONDIST
- FDIST
- FINV
- FTEST
- GAMMADIST
- GAMMAINV
- HYPGEOMDIST
Frequently asked questions
What does the BINOMDIST function do in Excel?
Legacy version of the binomial distribution — kept for compatibility with older files.
What is the syntax of BINOMDIST in Excel?
The syntax is =BINOMDIST(number_s, trials, probability_s, cumulative). number_s: The number of successes; trials: The number of independent trials; probability_s: The probability of success on a single trial; cumulative: TRUE for the cumulative distribution, FALSE for the probability mass.
Where can I practice BINOMDIST online for free?
Open the free live spreadsheet on Cellgrids and try BINOMDIST yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Compatibility functions · Excel case studies · Excel tutorials · Excel shortcuts