The `IMSUM` function in Excel is used to calculate the sum of complex numbers. A complex number has a real part and an imaginary part, and is usually expressed as `a + bi`, where `a` is the real part and `b` is the imaginary part.
Here’s how to use the `IMSUM` function:
Syntax
IMSUM(inumber1, [inumber2], ...)
- inumber1, inumber2, …: These are the complex numbers you want to sum. You can include 2 to 255 numbers.
Steps to Use IMSUM
=IMSUM(A1, B1)
- Enter Complex Numbers:
- Ensure that your complex numbers are in the form of text strings (e.g., “3+4i”) in the cells. Alternatively, they can be cell references to cells containing these string representations of complex numbers.
- Use IMSUM in a Formula:
- Click on the cell where you want the sum of the complex numbers to appear.
- Enter the formula using the `IMSUM` function. For example, if your complex numbers are in cells A1 and B1, you would enter:
- Evaluating the Result:
- After you press Enter, Excel will calculate the sum of the complex numbers and display the result as a complex number.
Example
If cell A1 contains “3+4i” and cell B1 contains “1-2i”, the formula:
=IMSUM(A1, B1)
will return “4+2i”, which is the sum of the complex numbers.
Notes
=COMPLEX(3, 4) // returns "3+4i"
- IMSUM handles the arithmetic addition of complex numbers by adding their real parts and their imaginary parts separately.
- If any input is not a valid complex number, IMSUM will return an error.
- You can create complex numbers using the `COMPLEX` function for more clarity. For example:
Using `IMSUM` is straightforward once you follow these steps, and it helps perform arithmetic operations on complex numbers easily in Excel.
Unlock Your Potential
Excel
Access
Power BI
