GESTEP in Calligra Sheets: Flag Values at or Above a Threshold

=GESTEP(4;3) has an independently expected result of 1 because 4 is at least 3; =GESTEP(2;3) expects 0. The optional threshold defaults to zero. All results here are independent arithmetic expectations, not Calligra runtime observations. The exact function name and 1–2-argument registration appear in KDE’s pinned 26.08.2 source; details are confirmed with the calculation branch, XML function definition and official handbook. Source consultation: 2026-10-13.

• First introduced: Introduction version not established.
• Current support: Registered in Calligra Sheets 26.08.2; see the function-specific source and official release listing. This is support evidence for that release, not a final supported version.
• Platform and retirement: The KDE application listing provides Linux installation. Other packaged platforms/builds and a retirement endpoint have not been established.
• Checked: October 14, 2026. Native test: Not executed in Calligra Sheets.

Examples use semicolons and decimal points, matching the English formula handbook. Numerical results were checked independently against the published implementation. Calligra itself was not run, so packaged-build behavior, locale handling and displayed errors remain untested.

=GESTEP(x)
=GESTEP(x;y)

The pinned registration permits one or two arguments, with an explicit alternate compatibility name COM.SUN.STAR.SHEET.ADDIN.ANALYSIS.GETGESTEP. This is a compatibility spelling of the same registered function; use the shorter name in ordinary formulas. KDE’s engineering XML and C++ registration were checked separately.

Optional input: the second argument has an explicit documented default of numeric zero only when omitted; a blank cell referred to as B2 is not the same evidentiary claim.

1. Open a blank Calligra Sheets document. Enter First input / value in A1, Second input / bound (optional) in B1, and Formula result in C1. Use D1 for notes if recording native observations later. Confirm the formula editor recognizes the = prefix and ; separator in your locale.
2. Type the numeric values below into A2:B14. Rows labelled omit optional argument are intentionally single-argument formulas; leave the B cell blank and do not pass B in that row’s formula. The blank column cell alone is not a demonstrated default.
3. Copy the displayed formula text for each row into the corresponding C cell. Each example uses its own references. Do not simply fill down a two-argument formula across single-argument rows.
4. Format the output column as an integer flag. Compare with the independent expected output column. The values are predictions derived outside Calligra, not screenshots or logs of native runs.
5. If running the test independently, note Calligra version, operating system, locale and any observed errors; do not treat source predictions as proof that the application returned them.

GESTEP converts a greater-than-or-equal numeric condition into a 1/0 flag. The first argument is the measured value and the second is the threshold. Order matters: =GESTEP(4;3) is independently expected to return 1, but =GESTEP(3;4) is expected to return 0. With the optional second argument omitted, the threshold defaults to zero. That makes =GESTEP(0) expected 1 and =GESTEP(-1) expected 0.

Implementation nuance: The pinned implementation returns 1 when its greater(x;y) numeric comparison is true or when approxEqual(x;y) is true. Consequently, source-level near-equality can affect a value extremely close to the cutoff; it is not necessarily the strict hardware floating-point comparison one might assume from >=. The approximate comparison uses a small relative tolerance and exact equality for internal integer pairs. This is static source logic, not evidence of a displayed result in an installed application. GESTEP branch; numeric comparison helper.

The source also explicitly returns the internal numeric-error value when either already-evaluated argument is of string type. This does not prove that =GESTEP("4";3) displays a particular error label: upstream parameter coercion may intervene. KDE’s XML describes numeric parameters and the handbook gives GESTEP(0.4;TRUE)→0; do not generalize from that one Boolean example to every mixed-type case.

Track a passing grade

Place grades 71, 82, 79, 90 in A2:A5 and a required score of 80 in E2. In B2 enter =GESTEP(A2;$E$2) and fill down through B5. The four independent expected flags are 0, 1, 0, 1; summing B2:B5 is independently expected to return 2 qualifying grades. Keep E2 absolute when filling. A grade of exactly 80 returns 1 because the boundary is inclusive.

Track inventory against a reorder threshold

Place quantities 0, 3, 6, 12 in A2:A5 and minimum stock 6 in E2. =GESTEP(A2;$E$2) produces expected flags 0, 0, 1, 1. This answers ‘at or above six’, not ‘should reorder’. To obtain a reorder alert for fewer than six items, the independent arithmetic transformation =1-GESTEP(A2;$E$2) gives 1, 1, 0, 0. Check the distinction before using it in an operational sheet.

Categorize deviations from zero

Enter -2, 0, 2 in A2:A4. Use =GESTEP(A2) in B2 and fill down for independent expected 0, 1, 1. If you need strictly positive, GESTEP by itself is not sufficient because zero qualifies under the documented omitted-threshold default; do not silently treat it as a greater-than-only test.

DELTA checks equality; GESTEP checks at least a cutoff. Both return numeric flags in their source implementations, making them useful for later count/sum arithmetic. An IF can return custom text such as =IF(GESTEP(A2;80);"Pass";"Review"), but the nested expression has not been executed in Calligra; verify it in the target installation. The official Calligra IF documentation confirms the separate IF function’s availability in the documented catalogue, not this composite test.

• Official GESTEP function entry
• 26.08.2 registration and argument count
• Function-specific parameter metadata
• Numeric equality and comparison helpers

These are documentation and source checks. All displayed results are independent expectations, not claims of an executed Calligra worksheet.