Author: Oscar Cronquist Article last updated on May 11, 2022

The BINOM.INV  function calculates the minimum value for which the binomial distribution is equal to or greater than a given threshold value.

The BINOM.INV function was introduced in Excel 2010 and has replaced the outdated CRITBINOM function.

Formula in cell C7:


Excel Function Syntax



trials Required. How many Bernoulli trials.
probability_s Required. The probability of success in each test.
Alpha Required. The threshold value.


The BINOM.INV function returns

  • #VALUE! error value if any argument is non-numeric.
  • #NUM! error value if:
    • trials < 0 (zero)
    • probability_s < 0 (zero)
    • alpha < 0 (zero)
    • alpha > 1