ID EN
#Engineering

IMSUB

Excel Functions

Get difference between two complex numbers

Syntax

EXCEL
=IMSUB(inumber1, inumber2)

Arguments

Parameter Description
inumber1 Complex number 1.
inumber2 Complex number 2.

Return Value

Difference between complex numbers as text

Details

The IMSUB function returns the difference between two complex numbers. For example: The result of the IMSUB function can be visualized by adding the opposite of the second vector tip-to-tail with the first. For example, the result of the subtraction below is visualized like this:

Examples

Example 1

The IMSUB function returns the difference between two complex numbers. For example:

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

The result of the IMSUB function can be visualized by adding the opposite of the second vector tip-to-tail with the first. For example, the result of

EXCEL
=IMSUB("4+3i","-2+5i") // returns "6-2i"

See Also

COMPLEX IMREAL IMAGINARY IMSUM IMPRODUCT