IMSUB
Returns the difference 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
IMSUB(inumber1,inumber2)
Inumber1 is the complex number from which to subtract inumber2.
Inumber2 is the complex number to subtract from inumber1.
Remarks
- Use COMPLEX to convert real and imaginary coefficients into a complex number.
- If either number is not in the form x + yi or x + yj, IMSUB returns the #NUM! error value.
- The difference of two complex numbers is:
Example
IMSUB("13+4i","5+3i")
equals 8 + i