ExcelFlux

CRITBINOM function

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

Compatibility

Where can you use it?

Teams maintaining legacy workbooks. Compare the example inputs and expected results with the formula in your workbook when checking a calculation made in an older version.

Scenario in the workbook

Check the legacy binomial cutoff. BINOM.INV serves the same purpose in newer workbooks.

A worked example from the workbook

RowA
6Value
70.1
80.5
90.9
Record 1
=CRITBINOM(2,0.5,A7)

Expected result0

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=CRITBINOM(2,0.5,A7)
Turkish Excel · tr-TR
=KRİTİKBİNOM(2;0,5;A7)

Compatibility function for older workbooks.

Worked examples

Check the legacy binomial cutoff. BINOM.INV serves the same purpose in newer workbooks.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A
6 Value
7 0.1
8 0.5
9 0.9
Case Formula Expected result
Record 1 =CRITBINOM(2,0.5,A7) 0
Record 2 =CRITBINOM(2,0.5,A8) 1
Record 3 =CRITBINOM(2,0.5,A9) 2
Microsoft Excel reference