What is the syntax for BINOM.DIST.RANGE in Excel?

The syntax for BINOM.DIST.RANGE is: =BINOM.DIST.RANGE(trials, probability_s, number_s, [number_s2])

What are common errors with BINOM.DIST.RANGE?

#NUM! if probability not between 0 and 1

How do I use the BINOM.DIST.RANGE function?

To use BINOM.DIST.RANGE, type =BINOM.DIST.RANGE( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.

What type of data does BINOM.DIST.RANGE work with?

BINOM.DIST.RANGE works with numerical data and can handle ranges, arrays, and individual values. It ignores text values and empty cells in its calculations, focusing only on numeric data for accurate statistical analysis.

Why is BINOM.DIST.RANGE not working in my Excel?

Common issues with BINOM.DIST.RANGE include #NUM! if probability not between 0 and 1. Start by checking the syntax =BINOM.DIST.RANGE(trials, probability_s, number_s, [number_s2]), then verify each referenced cell or range.

Statistical

BINOM.DIST.RANGE Function in Excel

Returns the probability of a trial result using a binomial distribution.

Syntax

=BINOM.DIST.RANGE(trials, probability_s, number_s, [number_s2])

Arguments

trials (required): Number of independent trials
probability_s (required): Probability of success on each trial
number_s (required): Minimum number of successes
number_s2 (optional): Maximum number of successes

Examples

=BINOM.DIST.RANGE(10, 0.5, 3, 7) - Probability of 3-7 successes in 10 trials - Result: 0.8906
=BINOM.DIST.RANGE(60, 0.75, 45) - Probability of exactly 45 successes - Result: Probability

BINOM.DIST.RANGE 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 probability not between 0 and 1

Use cases

Quality control
Risk analysis
Statistical testing

Frequently asked questions

What is the BINOM.DIST.RANGE function in Excel? BINOM.DIST.RANGE returns the probability of a trial result using a binomial distribution. The syntax is =BINOM.DIST.RANGE(trials, probability_s, number_s, [number_s2]). Typical use cases include quality control, risk analysis, statistical testing.
How do I use the BINOM.DIST.RANGE function? To use BINOM.DIST.RANGE, type =BINOM.DIST.RANGE( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
What type of data does BINOM.DIST.RANGE work with? BINOM.DIST.RANGE works with numerical data and can handle ranges, arrays, and individual values. It ignores text values and empty cells in its calculations, focusing only on numeric data for accurate statistical analysis.
Why is BINOM.DIST.RANGE not working in my Excel? Common issues with BINOM.DIST.RANGE include #NUM! if probability not between 0 and 1. Start by checking the syntax =BINOM.DIST.RANGE(trials, probability_s, number_s, [number_s2]), then verify each referenced cell or range.

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.