Microsoft Office Tutorials and References

In Depth Information

**IMAGINARY**

Figure 5.19

Returns the absolute

value of a complex

number.

IMAGINARY

IMAGINARY
returns the coefficient of a complex number in
x+yi
or
x+yj
text format.

=Imaginary(inumber)

The
IMAGINARY
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. Notice the example in Figure 5.20. The

complex numbers are converted to the imaginar y coefficients by using cell referencing.

The complex number to convert to an imaginar y coefficient.

INUMBER

Figure 5.20

Converts complex

numbers to imaginary

coefficients.