The IMSUM function returns the sum of two or more complex numbers in x + yi or x + yj text format. When adding complex numbers, the real and imaginary coefficients are added separately i.e., the equation to find the sum of two complex numbers a+bi and c + di is : (a + bi) + (c + di) = (a + c) + (b + d)i
Syntax:= IMSUM(inumber1, [inumber2], …)
The IMSUM function syntax has the following arguments:
- Inumber1, [inumber2], … Inumber1 is required, subsequent numbers are not. 1 to 255 complex numbers to add
Example: Let’s look at some Excel IMSUM function examples and explore how to use the IMSUM function as a worksheet function in Microsoft Excel:
Syntax: =IMSUM(A2,B2)
Result:
Based on the Excel spreadsheet above, the following IMSUM examples would return:
Syntax: =IMSUM(A3,B3)
Result: 4+3i
Syntax: =IMSUM(A4,B4)
Result: 15+3i
Syntax: =IMSUM(A5,B5)
Result: 2i
Syntax: =IMSUM(A6,B6)
Result: 15+2i
Syntax: =IMSUM(A7,B7)
Result: 10+240i
Syntax: =IMSUM(A8,B8)
Result: 18+7i
Syntax: =IMSUM(A9,B9,C9)
Result: 17+2i
Syntax: =IMSUM(A10,B10,C10)
Result: 14-10i
Syntax: =IMSUM(A11,B11,C11)
Result: 10-8i
Syntax: =IMSUM(A12,B12,C12)
Result: 113-35j
Syntax: =IMSUM(A13,B13,C13)
Result: 248+269i
Note:
- The formula returns the #NUM! error if the complex number doesn’t have lower case i or j (iota).
- The formula returns the #VALUE! Error if the complex number doesn’t have correct complex number format.
