Definition

Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.

Sample Usage

Syntax
BINOM.INV(trials,probability_s,alpha)
The BINOM.INV function syntax has the following arguments:
  • Trials     Required. The number of Bernoulli trials.
  • Probability_s     Required. The probability of a success on each trial.
  • Alpha     Required. The criterion value.
Remarks
  • If any argument is nonnumeric, BINOM.INV returns the #VALUE! error value.
  • If trials is not an integer, it is truncated.
  • If trials < 0, BINOM.INV returns the #NUM! error value.
  • If probability_s is < 0 or probability_s > 1, BINOM.INV returns the #NUM! error value.
  • If alpha < 0 or alpha > 1, BINOM.INV returns the #NUM! error value.
In order to use the BINOM.INV formula, start with your edited Excellentable:

Then type in the BINOM.INV formula in the area you would like to display the outcome:

By adding the values you would like to calculate the BINOM.INV formula for, Excellentable will generate the outcome:




  
    
      



    

        
        Error.
    

    
User does not have sufficient privileges to access this Content 
Learn More