GESTEP

What it does

GESTEP(number, [step])

GESTEP(number, [step]) returns numeric one when number>=step, and zero otherwise. The omitted threshold is zero. Equality belongs to the one-result side of the boundary.

Try it

=GESTEP(6,6) returns 1; =GESTEP(5,6) returns 0; =GESTEP(-0.5) returns 0. The threshold itself is included.

Quirks

The recorded wrapper reads the threshold before the first number. GESTEP(TRUE,#REF!) therefore returns #REF!, while GESTEP(#REF!,TRUE) returns #VALUE!. A logical is rejected in either slot, including through a cell reference; a blank cell instead reads as zero.

The represented number at the threshold gives one. There is no tolerance band. DELTA tests equality alone and does not include larger values.

How to implement

First read the optional threshold, using zero if omitted. Apply the nonlogical numeric conversion and return its error before reading the first number. Read the first number under the same rules. This is the second-argument-first order retained in the recorded controls.

Evaluate number>=step and map the result to numeric one or zero. In the example 6>=6 selects one. Preserve errors and failed conversion separately from a valid false comparison; an implementation that catches every failure and returns zero loses this distinction. Array lifting, if supplied by the host, must preserve its own error ordering.

Rust code

71 gestep "GESTEP" (1, 2) [V "number", V "step"] |s, a, sv| {
    let step = if given(a, 1) { super::kit::num_without_logical(s, a, 1)? } else { 0.0 };
    let x = super::kit::num_without_logical(s, a, 0)?;
    out(s, k::gestep_fn::gestep_kernel(x, step))
}

pub fn gestep_kernel(number: f64, step: f64) -> Result<f64, WorksheetErrorCode> {
    Ok(if number >= step { 1.0 } else { 0.0 })
}

No implementation has been published with a Handbook test suite for this function.

Version differences

The recorded environments below distinguish a reading from a same-input comparison. Counts describe captured inputs in each environment; overlapping captures and comparisons are not totals of unique worksheet calls.

The record contains no same-input comparison between these environments. Reading different inputs on different builds does not establish either a version change or cross-build agreement.

Recorded environments and comparison details.

Alternatives

DELTA identifies equal values; COUNTIF counts values at or above a threshold; IF selects arbitrary results.

Named variants

No named variants are recorded yet.