Difference between revisions of "Manuals/calci/IMCONJUGATE"

From ZCubes Wiki
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

  1. if imaginary number is '0' and
  2. and
  3. Real part (a)=z+z(bar)/2
  4. 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

See Also

References

Exponential function