Compatibility - CRITBINOM Function

The CRITBINOM function replaces the BINOM.INV function in Excel 2010.

Description

The function returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value. Use this function for quality assurance applications.

Syntax

CRITBINOM (trials,probability_s,alpha)

Arguments

Argument	Description	Required/Optional
Trials	The number of Bernoulli trials.	Required
Probability_s	The probability of a success on each trial.	Required
Alpha	The criterion value.	Required

Notes

If trials is not an integer, it is truncated.
If any argument is nonnumeric, CRITBINOM returns the #VALUE! error value.
If trials < 0, CRITBINOM returns the #NUM! error value.
If probability_s is < 0 or probability_s > 1, CRITBINOM returns the #NUM! error value.
If alpha < 0 or alpha > 1, CRITBINOM returns the #NUM! error value.

Example

advanced_excel_compatibility_functions.htm