The
IMAGINARY() function extracts and returns
the imaginary component from a complex
number..
- The syntax for the function
is IMAGINARY (inumber).
The
argument "inumber" is
a complex number of the form (a+bi) where
a and b are real number coeffcients.The
function returns the result in the form
of a real number b for example: IMAGINARY("2+3i")
= 3 where 3 is the real component of the
imaginary number 3i extracted from the
complex number (2+3i).To
learn more about real, imaginary and complex
numbers in mathematics see [The Mathematics
of Complex Numbers].
|
How
to use the IMAGINARY() function:
-
Type " =IMAGINARY( "
- Enter
the coordinate for the "a" data
cell "A2"
- Type")"
then press the "Enter" key.
|
|
|
|
Note: To comvert real and imaginary bumbers into
a complex number use the COMPLEX() function.
[The Complex function knowledgebase] |
