Syntax. BINOM.INV(trials;probability_s;alpha)

Definition. This function returns the smallest value for which the cumulative binomial distribution is greater than or equal to the specified probability. Use this function for quality assurance applications. For example, use the BINOM.INV() function to determine the largest number of defective parts that are allowed to come off an assembly line run without rejecting the entire lot.


  • trials (required). The number of Bernoulli trials

  • probability_s (required). The probability for the success of each trial

  • alpha(required). The cumulative binomial probability


If one of the arguments isn’t a numeric value, the BINOM.INV() function returns the #VALUE! error.

If trials isn’t ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.