GESTEP
Tests whether a number is greater than a threshold value.
EngineeringEngineering & Science
What it does
Returns 1 if number >= step, otherwise 0.
Syntax
GESTEP(number, [step])
Arguments
number(number) — Value to test.step(number) — Threshold (default 0).
Examples
Step Function
Check if 5 >= 4.
FORMULA
=GESTEP(5, 4)
RESULT
1
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Val | Step |
| 2 | 5 | 4 |