Purpose
Return value
Syntax
=IMSUM(inumber1,[inumber2],...)- inumber1 - Complex number 1.
- inumber2 - [optional] Complex number 2.
How to use
The Excel IMSUM function returns the sum of two or more complex numbers. For example:
=IMSUM("4+3i","2-5i") // returns "6-2i"Excel handles complex numbers as strings formatted like “x+yi” or “x+yj”. Use the COMPLEX function to get the string representing a complex number.
Examples
The IMSUM function takes in two or more arguments in the form inumber1, inumber2, inumber3, and so on. Arguments can be hard-coded values, cell references, or a range. Use the IMSUM function in a range like this:
=IMSUM(B6:B10) // sum complex numbers in B6:B10If Excel encounters values not recognized as complex numbers, a #NUM! Error is thrown.
=IMSUM("4+3i", "invalid input") // throws #NUM! errorExplanation
The sum of two complex numbers is visualized by arranging the arrows tip-to-tail and drawing an arrow from the origin to the tip of the second number. For example, the sum of "4+3i" and "2-5i" is visualized below, where the arrow "6-2i" is the sum of the complex numbers.
Image courtesy of wumbo.net.
Related functions
IMSUB Function
The Excel IMSUB function returns the difference between two complex numbers.
COMPLEX Function
The Excel COMPLEX function returns the string representation of a complex number.
IMREAL Function
The Excel IMREAL function returns the real part of a complex number.
IMAGINARY Function
The Excel IMAGINARY function returns the imaginary part of a complex number.
IMPRODUCT Function
The Excel IMPRODUCT function returns the product of one or more complex numbers.
