Excel GESTEP Function

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

  1. Click on an empty cell (like F5).
empty cell in excel

2. Click on the fx icon (or press shift+F3).

fx icon in excel

3. In the insert function tab you will see all functions.

insert function tab in excel

4. Select ENGINEERING category.

5. Select GESTEP function

6. Then select ok.

excel GESTEP function

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.

How to use GESTEP function in excel

Examples of GESTEP function in Excel

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.

Leave a Reply

Your email address will not be published. Required fields are marked *