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

How to use the IMSUB function

The IMSUB function calculates the difference between two 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

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

1. IMSUB Function Syntax

IMSUB(inumber1, inumber2)

Back to top

2. IMSUB Function Arguments

inumber1 Required. A complex number in x+yi or x+yj text format.
inumber2 Required. A complex number in x+yi or x+yj text format.

Back to top

3. IMSUB function example

How to use the IMSUB function

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

Formula in cell D3:

=IMSUB(C3, D3)

3.1 Explaining formula

Step 1 - Populate arguments

IMSUB(inumber1, inumber2)

becomes

IMSUB(C3, D3)

Step 2 - Evaluate the IMSUB function

IMSUB(C3, D3)

becomes

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

and returns

-4+6i

Back to top