IMDIV

Returns the quotient of two complex numbers in x + yi or x + yj text format.

If this function is not available, run the Setup program to install the Analysis ToolPak. After you install the Analysis ToolPak, you must enable it by using the Add-Ins command on the Tools menu.

Syntax

IMDIV(inumber1,inumber2)

Inumber1   is the complex numerator or dividend.

Inumber2   is the complex denominator or divisor.

Remarks

• Use COMPLEX to convert real and imaginary coefficients into a complex number.
• If inumber1 or inumber2 is not in the form x + yi or x + yj, IMDIV returns the #NUM! error value.
• The quotient of two complex numbers is:

  

Example

IMDIV("-238+240i","10+24i") equals 5 + 12i