Contact
12 programs
Explore the site

IMPRODUCT Function (Gnumeric)

Engineering Intermediate Gnumeric

Multiply complex values in Gnumeric; learn reproducible examples, magnitude checks, and troubleshooting.

Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Gnumeric. How formula examples are checked

Evidence boundary: The examples were independently calculated and checked against official documentation and the Gnumeric 1.12.62 source. Native execution, locale checks and file round-trips were not performed.

What IMPRODUCT does

IMPRODUCT multiplies complex numbers, useful for cascading phasor/transfer coefficients, repeated complex scale factors, and checking rectangular-form multiplication. It does not add series impedances: choose IMSUM for an appropriate addition calculation.

Version-specific error distinction: The online 1.12 manual describes malformed complex inputs as #VALUE!. The official 1.12.62 source instead returns #NUM! when parsing a malformed complex string; other unsupported value types can still return #VALUE!. Any #VALUE! expectations below are the manual’s older documented rule, not verified 1.12.62 output. No native error test was performed.

Official syntax and arguments

=IMPRODUCT(z1,z2,…)

z1, z2, and any additional values represent valid complex numbers. The official 1.12 manual shows both first arguments and the ellipsis; it does not specify a default or a universal maximum number of additional arguments. It documents #VALUE! when any argument is not a valid complex number. Use explicit scalar cell arguments for reproducibility, rather than assuming special behavior for ranges or blanks.

Reproducible worksheet

Cell Enter Mathematical interpretation
A2 2 First real coefficient
B2 3 First imaginary coefficient
C2 =COMPLEX(A2,B2) 2+3i
A3 1 Second real coefficient
B3 -2 Second imaginary coefficient
C3 =COMPLEX(A3,B3) 1−2i
D2 =IMPRODUCT(C2,C3) 8−1i (mathematical result)
D3 =IMREAL(D2) 8
D4 =IMAGINARY(D2) -1

Independent arithmetic: (2+3i)(1−2i)=2−4i+3i−6i²=8−i, because i²=-1. Text formatting may display the coefficient as -i or -1i; the components remain 8 and −1.

More fully reproducible examples

  • =IMPRODUCT("1+i","1-i") → mathematically 2+0i.
  • =IMPRODUCT(COMPLEX(2,3),COMPLEX(1,-2)) → mathematically 8−i.
  • Enter A4=-1, B4=1, C4=COMPLEX(A4,B4); then =IMPRODUCT(C2,C3,C4) → -7+9i.

Advanced application: cascading transfer factors

Use C2 and C3 to represent two dimensionless complex transfer factors (not impedances). =IMPRODUCT(C2,C3) gives their combined factor, and =IMABS(IMPRODUCT(C2,C3)) gives its gain magnitude, mathematically √65 ≈ 8.0622577483. Cross-check with =IMABS(C2)*IMABS(C3); mathematically √13 × √5 = √65. This checks the modulus identity independently of the complex-result display style. Do not interpret a gain above 1 as a stable or causal system property without further analysis.

Troubleshooting and limits

Symptom Evidence-based check
#VALUE! Official manual: an argument isn’t a valid complex value. Verify literal spelling and COMPLEX input construction.
Wrong sign of imaginary component Expand (a+bi)(c+di)=(ac−bd)+(ad+bc)i and remember i²=-1.
Apparent -i vs -1i difference Use IMREAL/IMAGINARY to check numeric components; display normalization has not been natively tested.
Range, blanks or mixed values The manual is not a full coercion matrix. Prefer explicit scalar references and test range behavior in the intended Gnumeric build.
Migrating from Excel The manual’s Excel-compatibility label does not guarantee the same range and error semantics or equivalent file import/export.

Compatibility

The official manual marks IMPRODUCT Excel-compatible. It says nothing about guaranteed byte-for-byte representation of results, full array support or identical handling of blanks. The function catalogue classifies it as a complete implementation with basic upstream tests—not exhaustive native validation of these examples.

Verification and applicability

These examples are independently calculated expectations, not observed output from a running Gnumeric installation. The published Gnumeric 1.12 manual documents the function’s signature and relevant error behavior, and the Gnumeric project’s function catalogue records upstream implementation and test classifications. The official 1.12.62 release announcement confirms that release exists (September 2026). The live manual/catalogue are not immutable 1.12.62 source-code snapshots, so document coverage must not be confused with runtime verification of every locale, platform, or build.

The examples use the English function names and the comma separators shown in the official manual. Your localized Gnumeric configuration might use another argument separator or decimal notation; use its Function Browser to confirm the accepted local entry format. Complex-number strings in the examples use the i suffix consistently. The Gnumeric manual also documents COMPLEX’s j suffix option, but do not mix conventions in one calculation without validating that workflow in your installation. Gnumeric is generally distributed through Linux/Unix-like systems and source packages; the project does not provide current official Windows binaries.

  • COMPLEX — construct consistent a+bi input strings from coefficients.

  • IMREAL — extract the real coefficient.

  • IMAGINARY — extract the imaginary coefficient.

  • IMSUM — add complex values.

  • IMABS — calculate the modulus.

  • IMPOWER — raise a complex value to a power.

Official evidence and limitations (checked 2026-10-13 UTC)

  1. Gnumeric Manual 1.12 — Complex functions: documented purpose, signature, argument meanings, #VALUE! notes, Excel-compatibility label and cross-references for IMPRODUCT. Dynamic 1.12-series documentation, not a pinned release source tree.
  2. Official Gnumeric function catalogue: improduct listed as Complete implementation with Basic upstream test classification; that describes upstream project metadata, not execution of this worksheet. The live catalogue currently presents an aggregate count that differs from the 1.12.62 release registry, so it is not used to assert catalogue completeness.
  3. Gnumeric 1.12.62 official release announcement: release existence and Excel/complex-function compatibility work (the release announcement does not guarantee each example or Excel round-trip).
  4. GNOME official 1.12 source-release directory: official versioned source distribution; the official 1.12.62 source was inspected for this review.

Evidence categories: official-manual documentation checks; official-catalogue metadata checks; independent arithmetic checks. Not performed: native function execution, locale-specific execution, Excel comparisons, GUI screenshots, or application screenshots.