The
IMPRODUCT() function returns the sum
of two or more complex numbers.
The syntax for the function
is IMPRODUCT(inumber1, inunmber2,.....inumber_n ).
The
arguments "inumber1,
inumber2, ...inumber_n " are
complex numbers of the form (a+bi) where
a and b are real number coeffcients.The
IMPRODUCT function calculates the product
of the two complex numbers and then returns
the result in the form of a complex number.
For example: IMPRODUCT("2+3i","6+2i")
=6 + 22i Where 6 is the real component
and 22 is the real component of the imaginary
number 22i. The function multiplies the
real and imaginary components of the complex
numbers independently i.e. (2+3i)*(6+2i)
= (2*6)+(3*2)i*i +(3i*6)+(2*2i) = (12-6)+(18i+4i)
= (6 + 22i) To learn more about real, imaginary
and complex numbers in mathematics see
[The Mathematics of Complex Numbers].
Note:To
convert real and imaginary numbers into
a complex number use the COMPLEX() function.
[The Complex function knowledgebase].
How
to use the IMPRODUCT() function:
Type " =IMPRODUCT( "
Enter
the coordinate for the data
cell "A2"
Type a comma.
Enter
the coordinate for the
data cell "B2".
Type")"
then press the "Enter" key.
Note:The "i" suffux
is commonly used in mathematics whereas
the "j" notation
is a more commonly used notation in electronic
fields. However both are used to represent
the vertical vector component of a complex
number when written in rectangular coordinates
or when graphed in complex space.
