Difference between revisions of "Manuals/calci/IMCONJUGATE"
Jump to navigation
Jump to search
Line 18: | Line 18: | ||
=IMCONJUGATE("8j")=0+-8j | =IMCONJUGATE("8j")=0+-8j | ||
=IMCONJUGATE("5+0i")=5+0i | =IMCONJUGATE("5+0i")=5+0i | ||
+ | |||
+ | {| id="TABLE3" class="SpreadSheet blue" | ||
+ | |- class="even" | ||
+ | !Equation | ||
+ | | a | ||
+ | | bi | ||
+ | | Result | ||
+ | | SUM | ||
+ | |- class="odd" | ||
+ | |=IMCONJUGATE("3+4i") | ||
+ | | 3 | ||
+ | | 4i | ||
+ | | 3+4i | ||
+ | | 3-4i | ||
+ | |- class="even" | ||
+ | | =IMCONJUGATE("6-7i") | ||
+ | | 6 | ||
+ | | -7i | ||
+ | | 6+7i | ||
+ | | | ||
+ | |- class="odd" | ||
+ | | =IMCONJUGATE("8j") | ||
+ | | 0 | ||
+ | | 8j | ||
+ | | 0+8j | ||
+ | | 0-8j | ||
+ | |- class="even" | ||
+ | | =IMCONJUGATE("2") | ||
+ | | 2 | ||
+ | | 0 | ||
+ | | 2+0i | ||
+ | | | ||
+ | |} | ||
==See Also== | ==See Also== |
Revision as of 04:27, 25 November 2013
IMCONJUGATE(z)
- where is the complex number.
Description
- This function gives the conjugate of a complex number.
- The complex number , then and it is denoted by or .
- So complex number and complex conjugate both also having same real number and imaginary number with
the equal magnitude and opposite sign of a imaginary number.Also
- if imaginary number is '0' and
- and
- Real part (a)=z+z(bar)/2
- Imaginary part(b)=z-z(bar)/2i.We can use COMPLEX function to convert the real and imginary coefficients to a complex number.
Examples
=IMCONJUGATE("3+4i")=3+-4i =IMCONJUGATE("6-7i")=6+7i =IMCONJUGATE("2")=2+0i =IMCONJUGATE("8j")=0+-8j =IMCONJUGATE("5+0i")=5+0i
Equation | a | bi | Result | SUM |
---|---|---|---|---|
=IMCONJUGATE("3+4i") | 3 | 4i | 3+4i | 3-4i |
=IMCONJUGATE("6-7i") | 6 | -7i | 6+7i | |
=IMCONJUGATE("8j") | 0 | 8j | 0+8j | 0-8j |
=IMCONJUGATE("2") | 2 | 0 | 2+0i |