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 IMSUBFunction in Excel
Formula
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
NOTE: #NUM! – Error occurs if,
supplied inumber arguments are not recognized as a complex number.
