Related Function:

The IMSUB function returns the difference of two complex numbers in x + yi or x + yj text format.




Argument Description
inumber1 The complex number from which to subtract inumber2
inumber2 The complex number to subtract from inumber1

Note: Use the COMPLEX function to convert real and imaginary coefficients into a complex number.


  A B C D
1 Data Formula Result Notes
2 3+4i =IMSUB(A2,A3) 1+5i Difference between the two complex numbers in the formula
3 2-i =IMSUB(“3+4i”,”2-i”) 1+5i  
4   =IMSUB(“2-i”,3) -1-i  
5   =IMSUB(“3+4i”,COMPLEX(4,1)) -1+3i  

Common Function Error(s)

Problem What went wrong
#NUM! Occurs if the supplied inumber argument is not recognized as a complex number
#NAME? Occurs when Analysis ToolPak add-in is not enabled

When subtracting complex numbers a+bi and c+di, the calculation is as follows:  

    \[   (a+bi) - c+di) = (a-c) + (b-d) i    \]

See Wikipedia for more information on complex numbers.