How to Use the IMSUM Function in Excel
The IMSUM function in Excel and Google Sheets is designed to calculate the sum of complex numbers. Each complex number consists of a real part and an imaginary part. This function is extremely useful for conducting mathematical computations involving complex numbers.
Syntax:
The syntax for the IMSUM function in Excel and Google Sheets is:
=IMSUM(inumber1, [inumber2], ...)inumber1– The first complex number, or a range containing complex numbers, to be included in the sum.inumber2(optional) – Subsequent complex numbers or ranges that you want to add.
Examples:
Example 1: Adding Complex Numbers
Consider the following two complex numbers in either Excel or Google Sheets:
| Cell A1 | Cell B1 |
|---|---|
| 3+2i | 1+5i |
To add these complex numbers together, use the IMSUM function as follows:
=IMSUM(A1, B1)This formula calculates the sum of the two complex numbers and outputs the result.
Example 2: Summing Multiple Complex Numbers
To sum more than two complex numbers, simply include all relevant cells in the IMSUM function. For instance:
| Cell A1 | Cell B1 | Cell C1 |
|---|---|---|
| 3+2i | 1+5i | 2+3i |
Enter the following formula to calculate the sum of these three complex numbers:
=IMSUM(A1, B1, C1)This function will efficiently compute and return the total sum of all included complex numbers.
The IMSUM function in Excel and Google Sheets proves to be a robust tool for handling complex numbers and performing advanced mathematical operations on them.
More information: https://support.microsoft.com/en-us/office/imsum-function-81542999-5f1c-4da6-9ffe-f1d7aaa9457f