Using the Excel IMSUM Function
SummaryThe Excel IMSUM function returns the sum of two complex numbers provided in the text format of x + yi or x + yj.
Use the COMPLEX function to convert real and imaginary coefficients into a complex number.
Syntax=IMSUM (inumber1, [inumber2], ...)
Required. The first complex number.
Optional. Additional complex numbers. The function accepts from 1 to 255 values.
Usage NotesIMSUM returns the sum of two or more complex numbers, up to 255 numbers. Arguments must be in the text format of x + yi or x + yj.
Only lowercase "i" and "j" will be accepted by the function. Any other value will result in the #NUM! error.