ExcelFlux

GESTEP function

Test — whether a number is greater than a threshold value.

Engineering

Where can you use it?

Engineering and technical analysis teams. If the calculation needs a number base, unit, complex number or special mathematical operation, check the input format against the example.

Scenario in the workbook

Flag readings at or above a minimum threshold. Equality passes.

A worked example from the workbook

RowAB
6First valueSecond value
777
867
987
Record 1
=GESTEP(A7,B7)

Expected result1

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=GESTEP(7,7)
Turkish Excel · tr-TR
=BESINIR(7;7)

Expected result

1

Worked examples

Flag readings at or above a minimum threshold. Equality passes.

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 B
6 First value Second value
7 7 7
8 6 7
9 8 7
Case Formula Expected result
Record 1 =GESTEP(A7,B7) 1
Record 2 =GESTEP(A8,B8) 0
Record 3 =GESTEP(A9,B9) 1
Microsoft Excel reference