IMSUM and IMSUB Functions - Sum and Complex Differences in Excel

This guide provides a practical overview of IMSUM and IMSUB Functions - Sum and Complex Differences, including its main features, benefits, limitations, and important considerations.

1. IMSUM function

Description: The function performs the sum of 2 or more complex numbers in excel.

Syntax: = IMSUM (inumber1, inumber2. ) .

Inside:

- inumber1, inumber2. : are complex numbers to be summed up, up to 255 complex numbers, at least have 2 complex numbers.

Attention:

- The sum of 2 complex numbers is calculated as follows:

For example:

Sum the following complex numbers:

In the first and second complex numbers, enter the following formula: IMSUM (B6, D6) -> Press Enter -> the sum of 2 and 1 complex numbers is:

In the cell to sum of 3 complex numbers, enter the formula: IMSUM (B6, C6, D6) -> The sum of 3 complex numbers is:

2. IMSUB function

Description: The function returns the difference of two complex numbers of the format x + yi or x + yj.

Syntax: IMSUB (inumber1, inumber2) .

Inside:

- inumber1 : The first complex number, is the subtracted number

- inumber2 : is the second complex number, minus number.

Attention:

- IMSUB function has only 2 parameters and cannot subtract 3 or more complex numbers.

- The difference is calculated based on the formula:

For example:

Calculate the difference of 2 complex numbers 1 and 2, 2 and 3.

In the cell to calculate difference of the 1st and 2nd complex numbers enter the formula: IMSUB (B6, C6) -> Press Enter -> the 1st and 2nd complex differences are:

In the cell you need to calculate the difference of the 2nd and 3rd complex numbers enter the formula: IMSUB (C6, D6) -> Press Enter -> the 2nd and 3rd complex differences are:

The above is a detailed guide on how to use and specific examples of IMSUM and IMSUB functions that hope to help you.

Good luck!