Formualizer Docs
ReferenceFunctionsEngineering Functions

GESTEP

GESTEP: Returns `1` when a number is greater than or equal to a step value.

Summary

Returns 0 when the number is below the step.

Remarks

  • If step is omitted, it defaults to 0.
  • Inputs are numerically coerced.
  • Propagates input errors.

Examples

Value meets threshold
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
1
Default threshold of zero
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0

FAQ

What default threshold does GESTEP use?

If omitted, step defaults to 0, so the function returns 1 for non-negative inputs.

Runtime metadata

Category

Engineering

Signature

GESTEP(arg1: Number, arg2…: Number)

Arity

min 1, max variadic

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/engineering.rs

ERFC

ERFC: Returns the complementary error function of a number.

HEX2BIN

HEX2BIN: Converts a hexadecimal text value to binary text.

On this page

SummaryRemarksExamplesRelated functionsFAQWhat default threshold does GESTEP use?Runtime metadata