Excel IMSUM Function

Using the Excel IMSUM Function

Excel IMSUM Function

Summary

The Excel IMSUM function returns the sum of two complex numbers provided in the text format of x + yi or x + yj.

Use the COMPLEX function to convert real and imaginary coefficients into a complex number.

Syntax

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

Syntax Breakdown

Inumber1
Required. The first complex number.

Inumber2
Optional. Additional complex numbers. The function accepts from 1 to 255 values.

Usage Notes

IMSUM returns the sum of two or more complex numbers, up to 255 numbers. Arguments must be in the text format of x + yi or x + yj.

Only lowercase "i" and "j" will be accepted by the function. Any other value will result in the #NUM! error.