IMSUB

Returns the difference between 2 complex numbers.

Syntax:

IMSUB(complexnum1, complexnum2)

Returns complexnum1 - complexnum2, where complexnum1 and complexnum2 are complex numbers as text, or references to cells containing complex numbers as text.

Example:

IMSUB("7+5i", "3+2i")

returns 4+3i as text.

IMSUM(A1, A2)

where cell A1 contains the text 3+4i and cell A2 contains 1+2i, returns 2+2i as text.

Application:

Imagine you are analyzing an electrical circuit and need to find the difference in impedance between two components. The impedance, which is a measure of the opposition to the flow of alternating current, is often represented by a complex number.

Impedance 1: A resistor and a capacitor in series have a combined impedance of 50+20i ohms.
Impedance 2: An inductor and another resistor have a combined impedance of 30+10i ohms.

You can use the IMSUB function to quickly calculate the difference between these two impedances.

Here's how you could set up a table:

	Parameter	Complex Number	Formula
	A	B	C
1	Impedance 1	50+20i	IMSUB(B1, B2)
2	Impedance 2	30+10i
3	Difference in Impedance	20+10i

In this table, the IMSUB function is used in cell C1 to subtract the complex number in cell B2 from the complex number in cell B1.

The formula IMSUB(B1,B2) automatically performs the subtraction: (50−30)+(20−10)i, resulting in 20+10i.

This function saves you from having to manually separate the real and imaginary components and perform the calculations, which is especially helpful when dealing with a large number of complex values.