IMSUB Function in Excel – Difference between two complex numbers

IMSUB Function in Excel returns the difference of two complex numbers .(i.e. subtracts one complex number from another).

Difference of Complex numbers:

When subtracting the complex numbers, the real and imaginary components are subtracted separately.i.e. the difference of two complex numbers a+bi and c+di is:(a+bi) – (c+di) = (a-c) + (b-d)i

 

Syntax of IMSUB Function in Excel 

IMSUB( inumber1, inumber2)

Where

  • inumber – arguments are the Complex Numbers that you want to find the difference of. i.e. inumber2 is to be subtracted from inumber1

 

Example of IMSUB Function in Excel

Formula

IMSUB Function in Excel 1

  • IMSUB Function takes up two complex numbers (real component and imaginary component) and subtracts them (finds the difference of them).
  • As we already discussed in complex number real and imaginary components are subtracted separately.

Result

IMSUB Function in Excel 2

NOTE: #NUM! – Error occurs if,

  • supplied inumber arguments are not recognized as a complex number.

previous-small IMSUB Function in Excel                                                                                                                next_small IMSUB Function in Excel