Practice free

CRITBINOM function

CRITBINOM finds the smallest number of successes whose cumulative binomial probability reaches a target, as used in quality-control acceptance limits. It is a compatibility function; use BINOM.INV in new workbooks.

Example

Read it as a sentence: find the smallest number of successes for which the cumulative chance reaches 0.5, using D1 (empty) as the number of tries and a 50% chance on each try.

Practice this in the app

Syntax

CRITBINOM(trials, probability_s, alpha)

trials (required)
Number of trials.
probability_s (required)
Chance of success on each trial.
alpha (required)
Target cumulative probability.

Returns: The smallest number of successes whose cumulative probability reaches alpha.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=CRITBINOM(4,0.5,0.5) 2 Working example
=CRITBINOM("4",0.5,0.5) 2 Text-number in first arg
=CRITBINOM({4,4},0.5,0.5) 2 Array in first arg (lifts, spills)
=CRITBINOM(Data!D1,0.5,0.5) 0 Blank cell as first arg
=CRITBINOM("abc",0.5,0.5) #VALUE! Non-numeric text in first arg
=CRITBINOM(NA(),0.5,0.5) #N/A Error in first arg
=CRITBINOM(4,0.5,0) #NUM! Alpha 0
=CRITBINOM(4,0.5,1) #NUM! Alpha 1

The Data sheet these formulas read

A cell that starts with = holds that formula.

Watch out for

  • Superseded by BINOM.INV; use that in new workbooks.

Where it works

Excel
CRITBINOM is in every version of Excel from 2007 on. Compatibility function: still works in every version, but newer replacements exist.
Google Sheets
Same name, same behaviour for everyday use.

Part of Compatibility functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .