How to use the Excel IMSUB function

Summary

The Excel IMSUB function returns the difference between two complex numbers. Complex numbers must be in the form x + yi or x + yj. Use the COMPLEX function to create complex numbers

Purpose

Get difference between two complex numbers

Return value

Difference between complex numbers as text

Syntax

=IMSUB (inumber1, inumber2)

Arguments

inumber1 - Complex number 1.
inumber2 - Complex number 2.

Version

Excel 2003

Usage notes

The IMSUB function gets the difference between two complex numbers in the form x + yi or x + yj. For example:

=IMSUB("1+2i",3) // returns "-2+2i"
=IMSUB("3+4i","1+2i") // returns "4i"

In the example shown, the formula in D6, copied down, is:

=IMSUB(B6,C6)

Related functions

Excel COMPLEX Function

The Excel COMPLEX function creates a complex number with given real and imaginary coefficients. COMPLEX returns a text result in the form x + yi or x + yj.

Excel IMREAL Function

The Excel IMREAL function returns the real coefficient of a complex number in the form x + yi or x + yj.

Excel IMAGINARY Function

The Excel IMAGINARY function returns the imaginary coefficient of a complex number given in the form x + yi or x + yj.

Excel IMSUM Function

The Excel IMSUM function returns the sum of two or more complex numbers. The complex numbers must be in the form x + yi or x + yj. Use the COMPLEX function to create a complex number from real...

Excel IMPRODUCT Function

The Excel IMPRODUCT function returns the product of one or more complex numbers. The complex number must be in the form x + yi or x + yj. Use the COMPLEX function to create a complex number...

500 Formulas | 101 Functions

Exceljet

Quick, clean, and to the point

Excel IMSUB Function

Download 200+ Excel Shortcuts

Excel video training