### CRITBINOM(trials, probability_s, alpha)

Returns the probability of getting greater than a particular value in a binomial distribution.

 trials The number of independent trials. probability_s The probability of a success on each trial. alpha The probability for the criteria.

#### Remarks

 * BINOM.INV was added in Excel 2010 to replace this function.* The binomial distribution is a discrete distribution.* This function assumes a cumulative probability function.* If "trials" < 0, then #NUM! is returned.* If "trials" is not an integer, it is truncated.* If "trials" is not numeric m then #VALUE! is returned.* If "probability_s" < 0, then #NUM! is returned.* If "probability_s" > 1, then #NUM! is returned.* If "probability" is not numeric, then #VALUE! is returned.* If "alpha" <= 0, then #NUM! is returned.* If "alpha" >= 1, then #NUM! is returned.* If "alpha" is not numeric, then #VALUE! is returned.* In Excel 2010 the accuracy of this function was improved.* For the Microsoft documentation refer to support.microsoft.com

 A 1 =CRITBINOM(6,0.5,9.38%) = 1.00 2 =CRITBINOM(6,0.5,23.44%) = 2.00 3 =CRITBINOM(6,0.5,BINOMDIST(3,6,0.5,FALSE)) = 2.00 4 =CRITBINOM(6,0.5,BINOMDIST(3,6,0.5,TRUE)) = 3.00 5 =CRITBINOM(6,0.5,0.75) = 4.00 6 =CRITBINOM(4,0.5,0.75) = 3.00 7 =CRITBINOM(4,0.5,0.9999) = 4.00 8 =CRITBINOM(4,0.5,0.0001) = 0.00 9 =CRITBINOM(4,0.5,-0.75) = #NUM! 10 =CRITBINOM(4,-0.5,0.75) = #NUM!