How to use the Excel IMSUM function

Summary

The Excel IMSUM function returns the sum of two or more complex numbers. The complex numbers must be in the form x + yi or x + yj. Use the COMPLEX function to create a complex number from real and imaginary parts.

Purpose

Get sum of complex numbers

Return value

Sum of complex numbers as text

Syntax

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

Arguments

inumber1 - Complex number 1.
inumber2 - [optional] Complex number 2.

Version

Excel 2003

Usage notes

Use the Excel IMSUM function to get the sum of two or more complex numbers in the form x + yi or x + yj. For example:

=IMSUM("1+2i",3) // returns "4+2i"
=IMSUM("3+4i","1+2i") // returns "4+6i"

In the example shown, the formula in D6, copied down, is:

=IMSUM(B6,C6)

Related functions

Excel COMPLEX Function

The Excel COMPLEX function creates a complex number with given real and imaginary coefficients. COMPLEX returns a text result in the form x + yi or x + yj.

Excel IMREAL Function

The Excel IMREAL function returns the real coefficient of a complex number in the form x + yi or x + yj.

Excel IMAGINARY Function

The Excel IMAGINARY function returns the imaginary coefficient of a complex number given in the form x + yi or x + yj.

Excel IMPRODUCT Function

The Excel IMPRODUCT function returns the product of one or more complex numbers. The complex number must be in the form x + yi or x + yj. Use the COMPLEX function to create a complex number...

500 Formulas | 101 Functions

Exceljet

Quick, clean, and to the point

Excel IMSUM Function

Download 200+ Excel Shortcuts

Excel video training