PlanMaker IMSUM: Add complex values component by component
IMSUM adds complex values by adding their real coefficients and their imaginary coefficients separately. The first argument is required; the documented signature permits additional complex arguments. No maximum argument count or range-expansion behavior is inferred here.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
IMSUM adds complex values by adding their real coefficients and their imaginary coefficients separately. The first argument is required; the documented signature permits additional complex arguments. No maximum argument count or range-expansion behavior is inferred here.
Availability and evidence
The 2026 function reference, 2024 reference and 2021 reference were retrieved and read on October 15, 2026. They establish documented support in those PlanMaker manual families. The original introduction and any last-working-version endpoint remain unverified; 2021 is the oldest reference checked here, not an introduction claim. Specific FreeOffice/mobile builds and every desktop platform were not tested.
The tables combine documented function rules with independent component arithmetic and high-precision mathematical calculations. No native PlanMaker execution, screenshot, export or import test was performed. Complex result components are used where native string formatting is not established. English examples use commas between arguments; adapt locale syntax only after checking the installed editor.
Exact syntax
=IMSUM(ComplexNum1 [, ComplexNum2, ComplexNum3 ...])
Syntax, explicit arguments and a vendor control
Arguments use the supported x+yi or x+yj representation. SoftMaker gives =IMSUM("2+4i","1+2i") with result 3+6i. Use the supported constructor COMPLEX when the coefficients are already numeric spreadsheet inputs.
The examples below pass separate cells explicitly. They do not assume that IMSUM accepts every range shape, ignores blanks or mixes i and j suffixes identically. Keep a consistent suffix and distinguish complex addition from joining strings with the text concatenation operator.
Reproducible pair sums
Create ComplexSums with X1,Y1,X2,Y2,First,Second,Sum,Sum_real,Sum_imaginary in A1:I1. Enter A:D below. Fill E2 =COMPLEX(A2,B2), F2 =COMPLEX(C2,D2), G2 =IMSUM(E2,F2), H2 =IMREAL(G2) and I2 =IMAGINARY(G2) through row 7.
| Row | A | B | C | D | Expected H | Expected I |
|---|---|---|---|---|---|---|
| 2 | 2 | 4 | 1 | 2 | 3 | 6 |
| 3 | 3 | 4 | -3 | 4 | 0 | 8 |
| 4 | 3 | 4 | -3 | -4 | 0 | 0 |
| 5 | -2 | 5 | 7 | -1 | 5 | 4 |
| 6 | 0 | 5 | 2 | 0 | 2 | 5 |
| 7 | 1.5 | -2 | 0.5 | 3 | 2 | 1 |
Check H with A+C and I with B+D. The table reports coefficients rather than enforcing a particular string representation of zero. In a copy change D2 from 2 to -2. H2 stays 3, while I2 changes from 6 to 2.
Advanced: add three explicit contributions
Create Contributions, with numeric pairs (3,4), (6,8), (-2,1) in A2:B4. Fill C2 =COMPLEX(A2,B2) through C4. Enter E2 =IMSUM(C2,C3,C4), then extract its real and imaginary coefficients. The expected result is (7,13).
As a separate grouping control, =IMSUM(IMSUM(C2,C3),C4) has the same mathematical coefficients. This tests component addition on small values; it does not guarantee bit-for-bit identical floating-point results for every grouping of huge or ill-scaled inputs.
Change A4 from -2 to 2 in a copy. The total becomes (11,13). Change only B4 from 1 to -1 in a fresh original copy: the total becomes (7,11). Independent component controls help find a sign or column-reference mistake.
Magnitude is calculated after the sum
On another sheet construct (3,4) and (-3,4) in A2:A3. =IMABS(IMSUM(A2,A3)) is mathematically 8, while =IMABS(A2)+IMABS(A3) is 10. The two real components cancel, but summing individual magnitudes cannot preserve that directional information.
With (3,4) and (-3,-4), the sum has zero coefficients and modulus 0, even though each input has modulus 5. This is mathematical cancellation, not evidence that the source entries were blank or invalid. Preserve both original contributions when explaining the result.
Errors and practical boundaries
The manual does not supply a full parser, coercion, omitted-argument or native overflow/error table. The documented first argument is required; the additional arguments are optional in the signature. Do not infer a missing input should be silently treated as complex zero.
Use IMSUB for an ordered difference, IMREAL and IMAGINARY for component checks, and IMABS for the final magnitude. Actual save/reopen, Excel transfer and localized syntax remain untested even when the mathematical operation has a counterpart elsewhere.
Verify in an installed version
Record the exact product/build, edition, platform, locale and workbook format. Enter the full source table, inspect components and apply the changed-input controls on separate copies. Keep full precision for calculations and round only the display. Saved-file recalculation and destination compatibility require their own tests.