Quantunet.com

My Account

Joins Us
Excel QuickSkills
The IMABS() Function Knowledgebase  

The IMABS() function calculates absolute value of a complex number.
  • The syntax for the function is IMABS(inumber).
The argument "inumber" is a complex number of the form (a+bi) where a and b are real number coeffcients.The IMABS function returns the absolute value (also known as modulus) of a complex number. For example: IMSUB("4+3i") = 5. The function squares the real and imaginary components independently adds them and then returns square root in the form of a real number. As (4+3i) = SQRT[(8)^2+(3i)^2] = SQRT[(16)+(9)] = SQRT[25]= 5. 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 IMABS() function:
  • Type " =IMABS( "
  • 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