Author: Oscar Cronquist Article last updated on November 21, 2022

How to use the IMSUM function

The IMSUM function calculates the total of two or more complex numbers in x + yi or x + yj text format.

The letter j is used in electrical engineering to distinguish between the imaginary value and the electric current.

C1 = x + yi

C2 = z + wi

IMSUM(C1, C2) = C1 + C2 = (x + yi) + (z + wi) = (x + z) + (y + w)i

1. IMSUM Function Syntax

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

Back to top

2. IMSUM Function Arguments

inumber1 Required. A complex number in x+yi or x+yj text format.
[inumber2] Optional. A complex number in x+yi or x+yj text format. Up to 255 complex numbers.

Back to top

3. IMSUM function example

How to use the IMSUM function

The image above demonstrates a formula in cell D3 that calculates the total of two complex numbers specified in cells C3 and D3.

Formula in cell D3:

=IMSUM(C3, D3)

3.1 Explaining formula

Step 1 - Populate arguments

IMSUM(inumber1, inumber2)

becomes

IMSUM(C3, D3)

Step 2 - Evaluate the IMSUM function

IMSUM(C3, D3)

becomes

IMSUM("2+2i","2-4i")

and returns

4-2i

Back to top