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