Returns the difference between two complex numbers.
Sample Usage
IMSUB("6+5i", "2+3i")
Syntax
IMSUB(first_number, second_number)
first_number- The complex number to subtractsecond_numberfrom.second_number- The complex number to subtract fromfirst_number.
Notes
- The difference between two complex numbers is defined as follows:
- (a+bi) - (c+di) = (a-c) + (b-d)i
- You can subtract two complex numbers only if they have the same suffix (i or j). For example, you can’t do
IMSUB("4+3i", "1+2j").
See also
- COMPLEX: The COMPLEX function creates a complex number, given real and imaginary coefficients.
- IMREAL: Returns the real coefficient of a complex number.
- IMAGINARY: Returns the imaginary coefficient of a complex number.
- IMSUM: Returns the sum of a series of complex numbers or cells or both.
Examples
| 1 | A | B |
|---|---|---|
| 2 | Formula | Result |
| 3 | =IMSUB("6+5i", "2+3i") | 4+2i |
| 4 | =IMSUB("20+5j", "4j") | 20+j |
| 5 | =IMSUB("20+5j", "4") | 16+5j |
| 6 | =IMSUB("20+5j", 4) | 16+5j |
| 7 | =IMSUB(COMPLEX(20, 5), COMPLEX(4, 0)) | 16+5i |