How to use IMSUM Function in Excel

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:

IMSUM Function - How to use IMSUM Function in Excel

Syntax:  =IMSUM(A2,B2)


IMSUM Function in Excel - How to use IMSUM Function in Excel

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


  • 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.

Add a Comment

Your email address will not be published. Required fields are marked *