Difference between revisions of "Manuals/calci/IMAGINARY"
Jump to navigation
Jump to search
Line 14: | Line 14: | ||
IMAGINARY("3j")=3 | IMAGINARY("3j")=3 | ||
IMAGINARY("7")=0 | IMAGINARY("7")=0 | ||
+ | |||
+ | {| id="TABLE3" class="SpreadSheet blue" | ||
+ | |- class="even" | ||
+ | !Equation | ||
+ | ! Real Part | ||
+ | ! Imaginary Part | ||
+ | ! Result(Imaginary) | ||
+ | |- class="odd" | ||
+ | |=IMAGINARY("2+3i") | ||
+ | | 2 | ||
+ | | 3i | ||
+ | | 3 | ||
+ | |- class="even" | ||
+ | | =IMAGINARY("4-5i") | ||
+ | | 4 | ||
+ | | -5i | ||
+ | | -5 | ||
+ | |- class="odd" | ||
+ | | =IMAGINARY("3j") | ||
+ | | 0 | ||
+ | | 3j | ||
+ | | 3 | ||
+ | |- class="even" | ||
+ | | =IMAGINARY("7") | ||
+ | | 7 | ||
+ | | 0 | ||
+ | | 0 | ||
+ | |} | ||
==See Also== | ==See Also== |
Revision as of 04:57, 28 November 2013
IMAGINARY(z)
- is the complex number is in the form .
Description
- This function gives the imaginary coefficient of a complex number.
- Imaginary number is a real number which is multiplied with the imaginary unit , where .
- When imaginary number is get adding to the real number , then it forms a complex number.
- Also when we are squaring the imaginary number , it will give the negative real number .
- For eg . We can use COMPLEX function to convert the real and imaginary coefficients to a complex number.
- A complex number is a imaginary number when the real part is zero.
Examples
IMAGINARY("2+3i")=3 IMAGINARY("4-5i")=-5 IMAGINARY("3j")=3 IMAGINARY("7")=0
Equation | Real Part | Imaginary Part | Result(Imaginary) |
---|---|---|---|
=IMAGINARY("2+3i") | 2 | 3i | 3 |
=IMAGINARY("4-5i") | 4 | -5i | -5 |
=IMAGINARY("3j") | 0 | 3j | 3 |
=IMAGINARY("7") | 7 | 0 | 0 |