GESTEP in ONLYOFFICE: Threshold Testing with Numeric Flags

Use GESTEP for a numeric minimum threshold: whether a batch temperature has reached a target, whether a count meets a target, whether a budget balance is nonnegative, or whether a measurement is at least a regulatory threshold. The return value is a numeric indicator, useful for adding up qualifying rows. GESTEP is different from DELTA: DELTA reports equality; GESTEP includes all values above the threshold as well. Vendor GESTEP; Vendor DELTA.

This is an exact comparison against the numeric values stored in the cells. If a tolerance around the threshold is needed, document and implement it separately; GESTEP has no vendor-documented tolerance parameter.

=GESTEP(number, [step])

The comparison is inclusive: equality satisfies the test. You can enter literals =GESTEP(5,5), references =GESTEP(B2,C2), or a default-zero form =GESTEP(B2). More than two arguments, a text threshold and array-spill behaviour are not covered by the vendor’s argument table; no native error or coercion result was observed.

1. Create a blank spreadsheet in an ONLYOFFICE Spreadsheet Editor edition you can identify. Use English formula language for the formulas below. Record your Desktop version or the actual Docs/server version and your region if you later report test results.
2. Enter the specified headers, then enter the table’s input values in the exact cells shown. Numeric inputs must be numeric cells (without quote marks).
3. Enter the formulas into the output cells exactly as shown, beginning with =. Use Formula → Function to find GESTEP or type the function directly. Fill down only through the named last row; do not accidentally include table headers.
4. Compare your displayed values against the independently computed expected column. For decimals, change display format or use numeric tolerance rather than expecting identical trailing digits.
5. If your result differs, record the formula, underlying cell type, software platform/version, displayed result, separator/locale settings and any error without overwriting the expected-value reference. ONLYOFFICE’s formula-entry and recalculation guide describes recalculating via the Formula tab, or F9 for the workbook.

In A1:G1, type Case, Measurement, Threshold, Formula, Expected threshold flag, Zero-default formula, Expected zero flag. Enter the listed B/C numbers into rows 2–14. Enter =GESTEP(B2,C2) in D2 and fill down to D14. Enter =GESTEP(B2) into F2 and fill through F14; this uses the vendor-documented omitted-step default of 0. Type the expected 1/0 values in E and G. Compare numeric D/E and F/G if executing a native editor test.

Notice that the equal rows pass and that a negative number can pass a more negative threshold; for example -3 is greater than -5. The dataset includes both sides of the exact 2.5 threshold. These 26 expected outputs were double-checked with Python and Decimal comparisons, not with an ONLYOFFICE runtime.

For the sample rows, =SUM(D2:D14) is mathematically expected to count 8 measurements passing their row-specific minimum; =SUM(F2:F14) counts 8 measurements that are nonnegative. Keep threshold cells numeric and document units in header text, not in numeric cells. To display Pass/Below target, the proposed formula =IF(GESTEP(B2,C2)=1,"Pass","Below target") is a user-facing rendering of the flag. The vendor separately documents IF and SUM.

GESTEP includes equality. Suppose exactly 10 units is allowed, but more than 10 requires investigation. GESTEP at step=10 would flag both 10 and 11. For a strictly greater-than rule, write a separate comparison, such as =IF(B2>C2,1,0). Do not claim GESTEP implements a strict comparison. Conversely, to classify a value within an inclusive interval [L,U], two logical comparisons such as =AND(B2>=L2,B2<=U2) are easier to audit; trying to assume a single threshold function handles both limits would be incorrect.

Place the observed result in column B and the required minimum in column C. Keep separate columns for calibrated instrument units and specimen identifiers rather than embedding labels into B or C. Compute column D’s numeric flag and summarize only the flags. The expected =GESTEP(-3,-5) flag is 1, because -3 exceeds the threshold -5. A green cell or conditional formatting is only a visual presentation and does not change the calculation; if the instrument tolerance is nonzero, record that as a separate mathematical acceptance rule.

Do not invent an error value. Where a case is mathematically defined but the editor’s coercion/overflow handling is undocumented, record it as native behaviour unverified, not a guaranteed #VALUE!, #NUM! or other message.

DELTA tests exact numeric equality, IF branches on a result, AND combines criteria and SUM counts numeric indicators. These links point to official vendor documentation.

Officially documented: The current, unversioned English ONLYOFFICE Docs Spreadsheet Editor function page for GESTEP and Insert Function catalogue list GESTEP as an Engineering function. Checked 2026-10-13 (UTC). This supports the existence, purpose and signature of the function in the documented editor; it is not proof of identical behaviour in all past web integrations, all Desktop Editors builds, or mobile versions.

First-supported version: Not established by this research. The vendor maintains distinct Docs release history and Desktop Editors release history. Their availability does not, by itself, identify the first supported release of GESTEP. Desktop version compatibility: NOT NATIVELY TESTED; browser/web version compatibility: NOT NATIVELY TESTED; historical versions: UNKNOWN; imported workbook round-trip and specific file-format compatibility: NOT TESTED.

English formulas: Examples use an initial = and commas between arguments where necessary, following the official Insert Function instructions. Under File → Advanced Settings, the editor offers Formula Language, Region, and decimal/thousands separators (official Advanced Settings guide). Translated formula names, regional separators and localized decimal entry are not verified here. Do not blindly swap commas for semicolons or translate a function name unless checked in the actual target installation.

Evidence classification: Every result labelled expected is derived from independent mathematical or logical computation, never copied from an ONLYOFFICE screenshot or claimed to have been observed in a running editor. Native Desktop executions: 0. Native web executions: 0. Any error strings described as possible diagnostic are not observed output.