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_number
from.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 |