MAX in WPS Spreadsheet: Highest Values, Ties and Numeric Floors

• First introduced: not established. The older official WPS Academy lesson, dated October 9, 2021, documents MAX; that date is not the introduction date.
• Current documented status: supported in the WPS Windows documentation updated July 13, 2026 and checked October 13, 2026.
• Version range: the reviewed Windows reference recommends a current WPS version but gives no minimum build or final supported build. Those boundaries are unknown.
• Last supported version: no retirement endpoint is documented. MAX is not marked retired by the reviewed sources.
• Other platforms: this guide does not extend the Windows evidence to every Mac, Linux, web or mobile release.
• Native testing: not performed; examples are documentation-based and independently calculated.

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

For a continuous numeric column, the usual form is:

=MAX(B2:B7)

You can supply numeric values or references. A colon joins the two ends of a rectangular range. Commas separate arguments in the examples here; use the separator accepted by your WPS locale. Optional-argument brackets are explanatory notation, not characters to paste.

The WPS entry guide supports direct formula entry or Formulas → Insert Function → MAX. Select an output cell outside the source range, enter the formula, and press Enter.

Enter this two-column table in A1:B7. All entries in B2:B7 should be genuine numbers. Keep any explanatory currency or unit label in a header or number format, rather than appending it to the cell value.

In E2 enter:

=MAX(B2:B7)

Expected result: 210. Cedar and Fir both recorded 210. MAX returns that shared value once; it does not resolve the tie or return either location name.

To make the tie visible, put this next to the maximum:

=COUNTIF(B2:B7,E2)

Expected result: 2. The maximum occurs twice. This is a useful reporting safeguard: a label such as “best location” is ambiguous unless the rule says how to handle ties. See COUNTIF in WPS Spreadsheet.

Put Gap below peak in C1. In C2 enter:

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

Fill down through C7.

Expected results, in order: 90, 125, 0, 50, 0, 115. The fixed reference $B$2:$B$7 keeps the comparison population unchanged while B2 becomes B3, B4 and so on.

Without dollar signs, copying the formula can shift the maximum’s range. That can produce plausible-looking but incomparable gaps. Inspect a formula near the bottom of the filled column to verify the reference has stayed fixed.

This calculation also shows why the maximum is not an average. One unusually high observation sets the benchmark for every row. If that observation is a data-entry mistake, the gap calculation will amplify the error; verify it before making a performance decision.

In a separate area, enter -18, -4, -11 and -9 in G2:G5, then use:

=MAX(G2:G5)

Expected result: -4. On the number line, -4 is greater than -9, -11 and -18. MAX does not mean “largest magnitude.” If you are measuring the size of losses, decide whether you mean the numerically greatest balance or the greatest absolute loss before building the report.

Do not include a zero argument merely to make a negative maximum disappear unless that is an intentional business rule.

Suppose J2 contains a requirement of 50 units and K2 contains available stock of 62 units. The raw difference J2-K2 is -12. If the business rule is “order the shortage, otherwise order zero,” use:

=MAX(J2-K2,0)

Expected result: 0. Now change K2 to 34. The expected result becomes 16.

This is a boundary rule, not a data-cleaning technique. The zero floor should not be used to conceal negative stock inputs or errors in the requirement. Validate J2 and K2 separately. The formula assumes both quantities use the same unit and that zero is the intended lower bound.

The official MAX FAQ recommends checking references, numeric data and formula punctuation when results are wrong.

• If an expected peak is missing, inspect its stored value and confirm it lies within the formula’s range.
• If the formula returns an error, inspect error values in the source rather than replacing them automatically with zero.
• If results change after filling down, inspect relative and absolute references.
• If several records tie, keep a count or a clearly documented selection rule next to the maximum.
• If rows are hidden or filtered, do not assume MAX means “visible rows only.” Use and verify an appropriate SUBTOTAL workflow for that requirement.

This article deliberately uses numeric datasets. The handling of empty ranges, logical constants, numeric text and mixed imported values should be tested in the actual WPS version before those edge cases are used as part of a critical calculation.

An Excel-like name is not proof that every advanced edge case is identical in WPS. For a future native check, record the exact Windows WPS build and locale, enter this dataset, verify 210 and the tie count of 2, test the negative-number result -4, then test both shortage cases. Save and reopen the workbook if it will be exchanged as XLSX.

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

Sources checked October 13, 2026. See editorial standards for the distinction between documented and native-tested examples.