GESTEP function
From Apache OpenOffice Wiki
< Documentation | How Tos
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Trigonometric
Hyperbolic
Rounding and remainders
Logarithm/Powers
Bessel functions
Miscellaneous
GESTEP
Returns 1 if a number is greater than or equal to a step number, or 0 otherwise.
This function is only available if the Analysis AddIn is installed.
Syntax:
GESTEP(number; stepnumber)
- returns 1 if number is greater than or equal to stepnumber (both being numbers). If stepnumber is omitted it is assumed to be 0.
Example:
GESTEP(4; 5)
- returns 0.
GESTEP(4; A1)
- where cell A1 contains 4, returns 1.
GESTEP(2)
- returns 1, because 2 is greater than 0.
=A1>=5
- in a cell, where cell A1 contains 4, shows FALSE, as 4 is not greater than or equal to 5. This approach is very similar to GESTEP but does not trap non-numeric arguments.
Issues:
- GESTEP should only be used with numbers - see issue 86283.
- GESTEP currently appears in the AddIn category of the Function Wizard.
See Also
