Excel IMSUB Function

Using the Excel IMSUB Function

Excel IMSUB Function

Summary

The Excel IMSUB function returns the difference between two complex numbers entered in text format of x +yi or x + yj.

Use the COMPLEX function to convert real and imaginary coefficients into a complex number.

Syntax

=IMSUB (inumber1, inumber2)

Syntax Breakdown

Inumber1
Required. Complex number from which inumber2 will be subtracted.

Inumber2
Required. Complex number to subtract from inumber1.

Usage Notes

IMSUB returns the difference between two complex numbers. The complex numbers must be in text format of x + yi or x + yj.

Only lowercase "i" and "j" will be accepted by the function. Any other value will result in the #NUM! error.