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:
Based on the Excel spreadsheet above, the following IMSUM examples would return:
- 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.