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 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.