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