Microsoft Office Tutorials and References

In Depth Information

**IMSUM**

The complex number to subtract from
Inumber 2
.

INUMBER 1

The complex number to subtract from
Inumber 1
.

INUMBER 2

Where the difference between two complex numbers is:

See the
COMPLEX
function earlier in this chapter for obtaining the complex number of real and

imaginar y coefficients.

Figure 5.34

Returns the difference

of two complex

numbers
x+yi
or
x+yj
in

text format.

IMSUM

IMSUM
returns the sum of two complex numbers
x+yi
or
x+yj
in text format.

=IMSUM(inumber1,inumber2,...)

The
IMSUM
function is found only if the Analysis Toolpak is installed. In addition it must be

turned on in the Add-Ins from the Tools menu. The example in Figure 5.35 shows the sum of

1-29 complex numbers when added together.

INUMBER 1
The complex number to add to inumber 1–29.

Where the addition or sum of two complex numbers are:

See the
COMPLEX
function earlier in this chapter for obtaining the complex number of real and

imaginar y coefficients.