IMSUM: Complex Addition and Documented Limit Conflicts in WPS Spreadsheet

=IMSUM(inumber1, [inumber2], ...)

Source warning: the formal parameter description says 1–255 inputs, the prose walkthrough says 1–29, and the illustrated function dialog says 1–30. The introduction describes two or more values, while the formal syntax appears to permit one. The maximum argument count and singleton behavior therefore remain unresolved. This guide uses only two or three explicit operands, which fit the documented addition purpose without relying on either disputed boundary.

Inputs are complex text using x+yi or x+yj notation, or references containing those values. Use a consistent imaginary suffix within a calculation. The examples do not establish mixed-suffix acceptance or exact returned-string formatting.

The official formula image supports the identity:

(a+bi)+(c+di) = (a+c)+(b+d)i

For =IMSUM("1+2i","3-2i"), the real coefficient is 1+3=4 and the imaginary coefficient is 2−2=0. The mathematical result is real, but this guide does not promise whether WPS displays it as a bare number, text or a complex string with a zero term.

For the three-input cancellation example, the real coefficients sum to 1+2−3=0 and the imaginary coefficients sum to 1−3+2=0. This is a genuine mathematical zero from three nonzero inputs, not a missing-value condition.

1. Enter text 2−4j in A2 and text 1+5j in B2, using the ordinary ASCII minus when typing the first value.
2. Enter =IMSUM(A2,B2) in C2.
3. Independently add the real coefficients, 2+1=3, and imaginary coefficients, −4+5=1.

The mathematical answer is 3+j. The vendor lesson demonstrates adding two columns through references, so this is a bounded adaptation of that workflow. No WPS workbook was opened or recalculated for this guide.

For hypothetical two-axis quantities represented by 1+2i and 3−2i, the summed imaginary component cancels while the real component becomes 4. That is component addition, not addition of magnitudes. The individual magnitudes would be square roots of 5 and 13, whose sum is greater than 4. Do not replace a complex sum with a sum of absolute values when direction matters.

This mathematical example also explains why adding a third quantity can reduce the final magnitude. Whether complex coefficients represent voltages, coordinates or another quantity depends on the surrounding model; IMSUM itself supplies no unit conversion or physical assumptions.

The source does not settle exact errors for malformed text, empty references, mixed suffixes or unsupported argument counts. The conflicting count statements are a documentation inconsistency, not evidence of a confirmed engine defect. Do not select one maximum by assuming that another spreadsheet has the same behavior.

SUM is an ordinary numeric aggregate and is not established here as an alias that parses complex text. The component tables describe independent arithmetic rather than literal runtime serialization. Precision, very large magnitudes, blank-containing ranges and array-spill behavior remain outside the established documentation/math scope.

The official WPS lesson is dated 2019-05-06 and explicitly labels its applicability WPS Office for Windows Personal. It does not identify a numeric release. This establishes documentation by that date, not the function’s original introduction or its last working version. Current build limits and equivalence across WPS clients remain unverified. The available evidence does not establish retirement or formal deprecation.

Checked October 18, 2026. The examples in this guide are original, independently calculated controls based on the lesson. They have not been run in WPS or another spreadsheet application. No screenshot or execution result is claimed.

SUM, SQRT.