IMSUBReturns 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 subtract second_number from.
second_number – The complex number to subtract from first_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