Excel Office

Excel How Tos, Tutorials, Tips & Tricks, Shortcuts

Tag: GESTEP function

GESTEP function: Description, Usage, Syntax, Examples and Explanation

What is GESTEP function in Excel? GESTEP function is one of Engineering functions in Microsoft Excel that returns 1 if number ≥ step; returns 0 (zero) otherwise. Use this function to filter a set of values. For example, by summing several GESTEP functions you calculate the count of values that exceed a threshold. Syntax of GESTEP function GESTEP(number, [step]) The GESTEP…