The IMSUB function returns the difference of two complex numbers in x + yi or x + yj text format. When subtracting complex numbers, the real and imaginary coefficients are subtracted separately i.e., the equation to subtract complex number c+di from complex number a + bi is: (a + bi) – (c + di) = (a – c) + (b – d)i
Syntax:= IMSUB (inumber1, inumber2)
The IMSUB function syntax has the following arguments:
- Inumber1: Required. The complex number from which to subtract inumber2.
-
Inumber2: Required. The complex number to subtract from inumber1.
Example: Let’s look at some Excel IMSUB function examples and explore how to use the IMSUB function as a worksheet function in Microsoft Excel:
Syntax: =IMSUB(A2,B2)
Result:
Based on the Excel spreadsheet above, the following IMSUB examples would return:
Syntax: =IMSUB(A3,B3)
Result: i
Syntax: =IMSUB(A4,B4)
Result: 3+3i
Syntax: =IMSUB(A5,B5)
Result: 0
Syntax: =IMSUB(A6,B6)
Result: 3+2i
Syntax: =IMSUB(A7,B7)
Result: -10+240i
Syntax: =IMSUB(A8,B8)
Result: 8+i
Syntax: =IMSUB(A9,B9)
Result: 2+8i
Syntax: =IMSUB(A10,B10)
Result: 1-13i
Syntax: =IMSUB(A11,B11)
Result: 2-14i
Syntax: =IMSUB(A12,B12)
Result: 87-44j
Syntax: =IMSUB(A13,B13)
Result: 228+216i
Note:
- The formula returns the #NUM! error if the complex number doesn’t have lower case i or j (iota).
- The formula returns the #VALUE! Error if the complex number doesn’t have correct complex number format.
