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:
Based on the Excel spreadsheet above, the following IMSUB examples would return:
- 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.