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 |