Quantunet.com

My Account

Joins Us
Excel QuickSkills
The IMCONJUGATE() Function Knowledgebase  

The IMCONJUGATE() function calculates absolute value of a complex number.
  • The syntax for the function is IMCONJUGATE(inumber).
The argument "inumber" is a complex number of the form (a+bi) where a and b are real number coeffcients.The IMCONJUGATE functionfinds the complex conjugate of the complex number in the argument. For example: IMCONJUGATE("4+3i") = 4-3i. A complex conjugate is the complemetary complex number such that when added togther the result is a real number. e.g. (4+3i) + (4-3i) = (4+4)+(3+-3)i = (8)+(0) = 8. To learn more about real, imaginary and complex numbers in mathematics see [The Mathematics of Complex Numbers].

Note: To convert real and imaginary numbers into a complex number use the COMPLEX() function. [The COMPLEX() function knowledgebase].


How to use the IMCONJUGATE() function:
  • Type " =IMCONJUGATE( "
  • Enter the coordinate for the data cell "A2".
  • Type")" then press the "Enter" key. 




 

Note: The"i" suffux is commonly used in mathematics whereas the "j" notation is a more commonly used notation in electronic fields. However both are used to represent the vertical vector component of a complex number when written in rectangular coordinates or when graphed in complex space.

© 2007 Quantunet LLC All Rights Reserved | Intellectual Property | Terms of Use | Privacy
Home | About Quantunet | FAQ's | Contact Us