IMSUB function in Excel

In this article, you will learn about the IMSUB function, its usage, syntax and how to use it in your excel spreadsheet.

IMSUB function in Excel

The IMSUB function in Excel returns the difference of two or more complex numbers in text format.

Syntax

= IMSUB(inumber1, inumber2)

The IMSUB function syntax has the following arguments:

  • Inumber1  – The first complex number.
  • Inumber2 – The second complex number to subtract from inumber1.

Possible Errors and Usage Notes

The complex numbers in the arguments must be in the form x + yi or x + yj. 

You can use the COMPLEX function to convert real and imaginary coefficients into a complex number.

Mathematical Equation

This function in Excel performs the calculations internally and returns the result, but it is necessary to understand how the program works and the mathematical equation behind the algorithm

Sum of two complex number is given by :

(a+bi)-(c+di)=(a-c)+(b-d)i

From the equation, the real parts of the complex equations get subtracted and the imaginary parts are subtracted separately.

How to use the IMSUB function in Excel?

Using this function in a WS is simple; all you need to do is enter the function as a formula of the cell in the formula bar.

Take a look at the given example

SUB function in Excel?

To find out the real coefficient of the complex numbers, Enter the complex numbers in columns A, and B and enter the following formula in Column C,

Formula: =IMSUM (A1,B1)

Here, A1 refers to the cell name or the cell address. Repeat the same to the other cells and you will get the difference of the complex numbers