How to Test Thresholds with DELTA and GESTEP in Excel

Flag machined parts that meet a strength minimum and an exact hole count with 1/0 tests that multiply into a pass/fail.

You will learn to

• Flag values at or above a threshold with GESTEP
• Flag exact matches with DELTA
• Multiply 1/0 flags to require every test

How it works

GESTEP(number, step) returns 1 if the number is greater than or equal to the step and 0 otherwise. DELTA(number1, number2) returns 1 if the two numbers are equal and 0 otherwise. Both return numbers rather than TRUE/FALSE, so you can add or multiply them directly.

Multiplying flags combines tests: =GESTEP(B4,I2)*DELTA(C4,I3) is 1 only when both checks pass. Adding a column of GESTEP results counts how many items meet a threshold.

=GESTEP(B2,I2)*DELTA(C2,I3)