The
IMSUM() function returns the sum of two
or more complex numbers.
The syntax for the function
is IMSUM(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
IMSUM function calculates the sum of complex
numbers and then returns the result in
the form of a complex number. For example:
IMSUM("2+3i","6+2i")
= 8+5i where 8 is the real component and
5 is the real component of the imaginary
number 5i. The function adds the real and
imaginary components of the complex numbers
independently i.e. (2+3i) + (6+2i) = (2+6)
+(3+2)i 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 IMSUM() function:
Type " =IMSUM( "
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.
