Microsoft Office Tutorials and References

In Depth Information

**IMPRODUCT**

and

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

imaginar y coefficients.

Figure 5.29

Returns a complex

number raised to a

power in
x+yi
or
x+yj

text format.

IMPRODUCT

IMPRODUCT
returns the product from 2 to 29 complex numbers in
x+yi
or
x+yj
text format.

=IMPRODUCT(inumber1,inumber2,...)

The
IMPRODUCT
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.30 shows the

complex numbers and their products. You can use from 1 to 29 complex numbers

INUMBER 1,2, ...
1 to 29 complex numbers to multiply.

The product of two complex numbers:

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

imaginar y coefficients.