Microsoft Office Tutorials and References

In Depth Information

**IMDIV**

Figure 5.23

Returns the cosine of a

complex number
x+yi

or
x+yj
in text format.

IMDIV

IMDIV
returns the quotient of complex numbers in
x+yi
or
x+yj
text format.

=IMDIV(inumber1,inumber2)

The
IMDIV
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 quotient of the complex number in the

first example in Figure 5.24 is .4-0.2i.

The complex numerator/dividend.

INUMBER 1

The complex denominator/divisor.

INUMBER 2

The quotient of the two complex numbers:

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

imaginar y coefficients.