Microsoft Office Tutorials and References
In Depth Information
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
Where the formula is:
Returns the complex
conjugate of a complex
number in x+yi or
x+yj text format.
IMCOS returns the cosine of a complex number x+yi or x+yj in text format.
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.