![]() |
Leading the way in Microsoft Office Development |
| Home | | | Excel | | | Word | | | PowerPoint | | | Consultancy | | | Feedback | | | Contact |
| Microsoft Excel > Functions > Engineering > GESTEP |
GESTEP(number [,step]) |
| Returns the boolean value depending if a number is greater than a threshold value. |
| number | The value to test against step. | |
| step | The threshold value. |
| REMARKS |
| This function is only available if you have the Analysis ToolPak add-in installed. | ||
| If "number" >= "step", then 1 is returned. | ||
| If "number" < "step", then 0 is returned. | ||
| If "step" is left blank, then 0 is used. | ||
| If any of the arguments are not numeric, then #VALUE! is returned. | ||
| This function can be used to filter out values. |
| EXAMPLES |
|
| Functions - G | Index - G | Office Online |
| Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved. | Top |