MIN in WPS Spreadsheet: Lowest Values, Zeros and Numeric Caps

• First introduced: not established. WPS Academy already documented MIN in its October 9, 2021 lesson, but the oldest located lesson does not prove introduction.
• Current documented status: supported in WPS Spreadsheet for Windows documentation updated July 13, 2026 and checked October 13, 2026.
• Supported build range: the current reference does not identify a minimum numeric build. It recommends a current WPS installation.
• Last supported version: no final build or retirement date established. The reviewed sources do not mark MIN as retired.
• Platform and edition: Windows documentation is the evidence scope. Other WPS clients and historic releases need separate verification.
• Native testing: not performed. No installed-version compatibility guarantee is implied.

=MIN(number1, [number2], ...)

The simplest range example is:

=MIN(B2:B7)

Numbers and cell/range references supply the values to compare. The brackets describe optional additional arguments. Do not type the brackets or ellipsis. Commas are shown as argument separators; check the installed locale if parsing fails.

Select an output cell outside the source data, type the formula, and press Enter. WPS also provides the guided Formulas → Insert Function workflow. The official instructions advise checking syntax and reference ranges before completing the formula.

Enter A1:B7 on a fresh worksheet. The durations below are all numeric and use the same unit, minutes.

=MIN(B2:B7)

Expected result: 12. Two deliveries share this minimum. The formula returns the duration, not the word East or Central.

If the minimum is stored in E2, count its occurrences with:

=COUNTIF(B2:B7,E2)

Expected result: 2. For a report naming the fastest delivery, preserve ties or specify a separate rule. It is not safe to interpret MIN itself as selecting one record.

=MAX(B2:B7)-MIN(B2:B7)

Expected result: 19. The largest duration is 31 and the smallest is 12. Their difference describes the range of the observed values, not the average variation or a standard deviation.

To calculate each delivery’s distance above the minimum, put this in C2 and fill down through C7:

=B2-MIN($B$2:$B$7)

Expected results: 6, 13, 0, 8, 0, 19. Dollar signs keep the minimum’s population fixed. Only the individual B-row reference should move while filling down.

As a separate controlled test, replace B7’s 31 with the number 0. The formula =MIN(B2:B7) now has an expected result of 0.

That is mathematically correct if zero really means a zero-minute observation. It is misleading if someone used zero to mean “not measured.” MIN cannot infer the intended meaning of a placeholder. Correct the data model or use a documented conditional-minimum workflow; do not silently treat every zero as missing.

Restore B7 to 31 before returning to the other examples. Keeping test changes explicit prevents a later formula from appearing wrong because an earlier experiment changed the inputs.

Enter -3, -14, -8 and 2 in G2:G5.

=MIN(G2:G5)

Expected result: -14. It is the furthest left on the number line. MIN does not choose the smallest absolute magnitude; that would require a different question and calculation.

For temperatures, account movements or stock adjustments, retain the sign’s meaning throughout the workbook. Removing signs before taking the minimum changes the analysis.

Put a requested quantity of 28 in J2 and available stock of 19 in K2. For a policy that permits allocation up to the smaller of those two nonnegative quantities, use:

=MIN(J2,K2)

Expected result: 19. Change J2 to 8 while leaving stock at 19; the expected allocation becomes 8.

This compact rule assumes both inputs are valid, nonnegative counts in the same unit. If the request were -4, an ordinary minimum could return -4. That is a validation issue, not a reason to silently reinterpret MIN. If the business explicitly requires a zero floor as well as a stock ceiling, validate that stock is nonnegative and document the rule before using a construction such as MAX(0,MIN(J2,K2)).

The WPS MIN FAQ specifically points to reference ranges, numeric values, separators and copied references.

The worked examples intentionally avoid empty ranges and mixed logical/text inputs. If those cases matter, test them in the named WPS build rather than importing another application’s edge-case rules.

For a future native test, record the WPS version, operating system and locale. Check the minimum 12, tie count 2, spread 19, zero test 0, negative result -14, and allocation results 19 and 8. Restore the original data between tests. Reopen and recalculate the saved workbook before relying on an exchanged file.

This distinction matters: the official documentation establishes product support, while a native test establishes observed behavior in a particular version. Only the first and the independent arithmetic checks have been completed for this article.

• WPS MIN for Windows: introduction.
• WPS MIN for Windows: how to use.
• WPS MIN for Windows: FAQ.
• WPS Academy: AVERAGE, MAX and MIN.

Sources checked October 13, 2026. See editorial standards.