Purpose
Get sum of complex numbers
Return value
Sum of complex numbers as text
Syntax
=IMSUM(inumber1,[inumber2],...)- inumber1 - Complex number 1.
- inumber2 - [optional] Complex number 2.
How to use
Use the Excel IMSUM function to get the sum of two or more complex numbers in the form x + yi or x + yj. For example:
=IMSUM("1+2i",3) // returns "4+2i"
=IMSUM("3+4i","1+2i") // returns "4+6i"
In the example shown, the formula in D6, copied down, is:
=IMSUM(B6,C6)
Related functions
COMPLEX Function
The Excel COMPLEX function creates a complex number with given real and imaginary coefficients. COMPLEX returns a text result in the form x + yi or x + yj....
IMREAL Function
The Excel IMREAL function returns the real coefficient of a complex number in the form x + yi or x + yj.
IMAGINARY Function
The Excel IMAGINARY function returns the imaginary coefficient of a complex number given in the form x + yi or x + yj.
IMPRODUCT Function
The Excel IMPRODUCT function returns the product of one or more complex numbers. The complex number must be in the form x + yi or x + yj. Use the COMPLEX function to create a complex number from real and imaginary parts.
