Purpose
Return value
Syntax
=IMSUB(inumber1,inumber2)- inumber1 - Complex number 1.
- inumber2 - Complex number 2.
How to use
The IMSUB function returns the difference between two complex numbers. For example:
=IMSUB("4+3i","1+2i") // returns "3+i"Excel handles complex numbers as strings formatted like "x+yi" or "x+yj". Use the COMPLEX function to get the string representing a complex number.
Explanation
The result of the IMSUB function can be visualized by adding the opposite of the second vector tip-to-tail with the first. For example, the result of the subtraction below
=IMSUB("4+3i","-2+5i") // returns "6-2i"is visualized like this:
Related functions
COMPLEX Function
The Excel COMPLEX function returns the string representation of a complex number.
IMREAL Function
The Excel IMREAL function returns the real part of a complex number.
IMAGINARY Function
The Excel IMAGINARY function returns the imaginary part of a complex number.
IMSUM Function
The Excel IMSUM function returns the sum of two or more complex numbers.
IMPRODUCT Function
The Excel IMPRODUCT function returns the product of one or more complex numbers.
