IMSUM Function in Google Sheets

Add multiple complex numbers using the IMSUM function.

IMSUM Function

The IMSUM function in Google Sheets adds multiple complex numbers together.

Syntax

IMSUM(value1, [value2, ...])
  • value1: The first complex number to add. This is a required parameter.
  • value2, ...: Additional complex numbers to add. These are optional.

Examples

  1. Adding Two Complex Numbers

Add the complex numbers 1+2i and 3+4i:

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

This will output 4+6i.

  1. Adding Multiple Complex Numbers

Add the complex numbers 1+2i, 3+4i, and 5+6i:

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

This will output 9+12i.

Notes

  • The function can handle multiple complex numbers in one call.
  • Complex numbers should be provided as strings in the form “a+bi”.
  • IMPRODUCT: Multiply multiple complex numbers.
  • IMSUB: Subtract one complex number from another.