Microsoft Office Tutorials and References

In Depth Information

**IMSUB**

Where the square root of a complex number is as follows:

where

and

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

imaginar y coefficients.

Figure 5.33

Returns the square root

of complex numbers

x+yi
or
x+yj
in text

format.

IMSUB

Returns the difference of two complex numbers in
x+yi
or
x+yj
text format with
IMSUB
.

=IMSUB(inumber1,inumber2)

The
IMSUB
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.34 shows the difference when

two complex numbers are subtracted.