ID EN
#Engineering

IMSUM

Excel Functions

Get sum of complex numbers

Syntax

EXCEL
=IMSUM(inumber1, [inumber2], ...)

Arguments

Parameter Description
inumber1 Complex number 1.
inumber2 [optional] Complex number 2.

Return Value

Sum of complex numbers as text

Details

The Excel IMSUM function returns the sum of two or more complex numbers. For example: 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: If Excel encounters values not recognized as complex numbers, a #NUM! Error is thrown. 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.

Examples

Example 1

The Excel IMSUM function returns the sum of two or more complex numbers. For example:

EXCEL
=IMSUM("4+3i","2-5i") // returns "6-2i"
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 refere

EXCEL
=IMSUM(B6:B10) // sum complex numbers in B6:B10
Examples

If Excel encounters values not recognized as complex numbers, a #NUM! Error is thrown.

EXCEL
=IMSUM("4+3i", "invalid input") // throws #NUM! error

See Also

IMSUB COMPLEX IMREAL IMAGINARY IMPRODUCT