Quantunet.com

My Account

Joins Us
Excel QuickSkills
The IMSUB() Function Knowledgebase  

 

The IMSUB() function calculates the difference between complex numbers.

  • The syntax for the function is IMSUB(inumber1, inumber2).

The arguments "inumber1" and "inumber2" are complex numbers of the form (a+bi) where a and b are real number coeffcients. The argument "inumber2" is subtracted from "inumber1".

The IMSUB function returns the difference between two complex numbers. For example: IMSUB("8+3i", "5+6i") =3-3i. The function subtracts the real and imaginary components independently and then returns the result in the form of a complex number e.g. (8+3i) - (5+6i) = (8-5) + (3-6)i = 3-3i.

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 IMSUB() function:

  • Type " =IMSUB( "
  • Enter the coordinate for the data cell "A2".
  • Type a comma.
  • Enter the coordinate for the data cell "B2".
  • 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