Microsoft Office Tutorials and References
In Depth Information
IMSIN
IMSIN
IMSIN returns the sine of complex numbers x+yi or x+yj in text format.
=IMSIN(inumber)
The IMSIN 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.32 shows the
complex numbers converted to the sine of the complex number.
INUMBER The complex number to convert to its sine.
Where the sine of the complex number is:
See the COMPLEX function earlier in this chapter for obtaining the complex number of real and
imaginar y coefficients.
Figure 5.32
Returns the sine of
complex numbers x+yi
or x+yj in text format.
IMSQRT
Returns the square root of a complex number in x+yi or x+yj text format.
=IMSQRT(inumber)
The IMSQRT 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.33 shows the
complex numbers converted converted to their square roots.
The complex number you wanted the square root of.
INUMBER
Search JabSto ::




Custom Search