Using the Excel IMSUB Function
SummaryThe Excel IMSUB function returns the difference between two complex numbers entered in text format of x +yi or x + yj.
Use the COMPLEX function to convert real and imaginary coefficients into a complex number.
Syntax=IMSUB (inumber1, inumber2)
Required. Complex number from which inumber2 will be subtracted.
Required. Complex number to subtract from inumber1.
Usage NotesIMSUB returns the difference between two complex numbers. The complex numbers must be in text format of x + yi or x + yj.
Only lowercase "i" and "j" will be accepted by the function. Any other value will result in the #NUM! error.