Purpose
Return value
Syntax
=IMSUB(inumber1,inumber2)- inumber1 - Complex number 1.
- inumber2 - Complex number 2.
How to use
The IMSUB function gets the difference between two complex numbers in the form x + yi or x + yj. For example:
=IMSUB("1+2i",3) // returns "-2+2i"
=IMSUB("3+4i","1+2i") // returns "4i"
In the example shown, the formula in D6, copied down, is:
=IMSUB(B6,C6)
Related functions
COMPLEX Function
The Excel COMPLEX function creates a complex number with given real and imaginary coefficients. COMPLEX returns a text result in the form x + yi or x + yj.
IMREAL Function
IMAGINARY Function
IMSUM Function
The Excel IMSUM function returns the sum of two or more complex numbers. The complex numbers must be in the form x + yi or x + yj. Use the COMPLEX function to create a complex number from real and imaginary parts.
IMPRODUCT Function
The Excel IMPRODUCT function returns the product of one or more complex numbers. The complex number must be in the form x + yi or x + yj. Use the COMPLEX function to create a complex number from real and imaginary parts.
