Statistical
BINOM.INV Function in Excel
Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.
Syntax
- =BINOM.INV(trials, probability_s, alpha)
Arguments
- trials (required): Number of trials
- probability_s (required): Probability of success
- alpha (required): Criterion value
Examples
- =BINOM.INV(10, 0.5, 0.75) - Inverse binomial - Result: 6
BINOM.INV for data analysis
- Confirm whether you need entire columns, filtered subsets, or distinct values.
- Use [COUNTIFS](/functions/countifs/) and [SUMIFS](/functions/sumifs/) for multi-criteria metrics.
- Pivot tables complement single-cell statistical formulas for exploration.
Common errors
- #NUM! if parameters invalid
Use cases
- Statistical thresholds
- Quality control
- Decision making
Frequently asked questions
- What is the BETA.INV function in Excel? BETA.INV returns the inverse of the beta cumulative distribution. Given a probability, it returns the corresponding x-value, useful for finding percentiles in beta-distributed data.
- How do BETA.DIST and BETA.INV work together? They're inverse functions. If BETA.DIST(x, alpha, beta, TRUE) = p, then BETA.INV(p, alpha, beta) = x. Use BETA.INV to find values at specific probability levels.
- What is a practical use case for BETA.INV? In project management, if task duration follows a beta distribution, use BETA.INV to find the duration that has a 90% probability of completion (90th percentile).
Editorial review
- Reviewed by Excel.Directory Editorial Team. Updated May 2026.