Microsoft Office Tutorials and References

In Depth Information

**IMCOS**

IMCONJUGATE
is found only if the Analysis Toolpak is installed. In addition it must be turned

on in the Add-Ins from the Tools menu. Where the complex number in Figure 5.22 is 3+4i,

the complex conjugate results in 3-4i.

The complex number you want converted to the complex

conjugate.

INUMBER

Where the formula is:

Figure 5.22

Returns the complex

conjugate of a complex

number in
x+yi
or

x+yj
text format.

IMCOS

IMCOS
returns the cosine of a complex number
x+yi
or
x+yj
in text format.

=IMCOS(inumber)

The
IMCOS
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
IMCOS
function returns the cosine of the

complex number as shown in Figure 5.23.

INUMBER
The complex number to convert to the cosine.

Where the cosine of the complex number is:

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

imaginar y coefficients.