Quantunet.com

My Account

Joins Us
Excel QuickSkills
The IMREAL() Function Knowledgebase  

The IMREAL() function returns the sum of two or more complex numbers.
  • The syntax for the function is IMREAL(inumber).
The argument "inumber1" is a complex number of the form (a+bi) where a and b are real number coeffcients.The IMREAL function extracts the real component of the complex number. For example: IMREAL("5+3i") =5 where 5 is the real component of the complex number.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 IMREAL() function:
  • Type " =IMREAL( "
  • 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