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 |