Syntax
=GESTEP(number, [step])Arguments
| Argument | Required | Description |
|---|---|---|
number | Required | The value to test |
step | Optional | The threshold (0 when left out) |
How to use GESTEP
GESTEP takes 1 required argument and 1 optional argument. Type =GESTEP( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=GESTEP(5, 4)Result =GESTEP(-4, -5)Result =GESTEP(-1)Result Related engineering functions
- ERFReturns the error function integrated between zero (or a lower limit) and an upper limit.
- ERF.PRECISEReturns the error function integrated between zero and a limit.
- ERFCReturns the complementary error function integrated between a value and infinity.
- ERFC.PRECISEReturns the complementary error function integrated between a value and infinity.
- HEX2BINConverts a hexadecimal number to binary.
- HEX2DECConverts a hexadecimal number to decimal.
- HEX2OCTConverts a hexadecimal number to octal.
- IMABSReturns the absolute value (modulus) of a complex number.
- IMAGINARYReturns the imaginary part of a complex number.