Microsoft Office Tutorials and References

In Depth Information

**IMREAL**

Figure 5.30

Returns the product

from 2 to 29 in

complex numbers
x+yi
or

x+yj
text format.

IMREAL

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

=IMREAL(inumber)

The
IMREAL
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.31 shows the

complex numbers and their real coefficients.

INUMBER
The complex number to convert to the real coefficient.

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

imaginar y coefficients.

Figure 5.31

Returns real

coefficients of complex

numbers
x+yi
or
x+yj

in text format.