What is GESTEP function in Excel?
The GESTEP function is one of the Engineering functions of Excel.
It Tests whether a number is greater than a threshold value.
We can find this function in Engineering category of the insert function Tab.
How to use GESTEP function in excel
- Click on an empty cell (like F5).
2. Click on the fx icon (or press shift+F3).
3. In the insert function tab you will see all functions.
4. Select ENGINEERING category.
5. Select GESTEP function
6. Then select ok.
7. In the function arguments Tab you will see GESTEP function.
8. Number section is the value to test against step.
9. Step section is the threshold value.
10. You will see the results in the formula result section.
Examples of GESTEP function in Excel
GESTEP related functions
- GROWTH function
- Use LOG function to return the logarithm of a number to the base you specify.
