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

How to use the IMDIV function

The IMDIV function calculates the quotient of two complex numbers in x + yi or x + yj text format.

The quotient is the result of dividing one complex number inumber1 by another complex number inumber2. The numerator is inumber1  and the denominator is inumber2.

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

The quotient of two complex numbers is calculated like this:

z1 = a+ib

z2 = c+id

IMDIV(z1,z2) = (a+ib)/(c+id) = ((ac+bd) + (bc-ad)i)/(c2+d2)

1. IMDIV Function Syntax

IMDIV(inumber1, inumber2)

Back to top

2. IMDIV Function Arguments

inumber1 Required. The complex numerator in x+yi or x+yj text format.
inumber2 Required. The complex denominator in x+yi or x+yj text format.

Back to top

3. IMDIV function example

How to use the IMDIV function

The image above demonstrates a formula in cell D3 that calculates the hyperbolic cosecant of a complex number specified in cell C3.

Formula in cell F3:

=IMDIV(C3, D3)

3.1 Explaining formula

Step 1 - Populate arguments

IMDIV(inumber1, inumber2)

becomes

IMDIV(C3, D3)

Step 2 - Evaluate the IMDIV function

IMDIV(C3, D3)

becomes

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

and returns

-0.6-0.2i

Back to top