An imaginary coefficient with a real coefficient makes up a complex number. Real and imaginary coefficients can be transformed into complex numbers of the type x + yi or x + yj. Therefore, you may need to do subtraction between the complex numbers. To do the task, this article will demonstrate how to use the IMSUB function in Excel.
IMSUB Function Overview
Objective
The objective of the Excel IMSUB function is to  determine the difference between two complex numbers
Syntax
=IMSUB(inumber1,inumber2 )
Arguments Explanation
Argument | Required/Optional | Explanation |
---|---|---|
inumber1 | Required | Complex Number 1. |
inumber2 | Required | Complex number 2. |
Version
- The IMSUB function is available from Microsoft Excel 2007.
- Here, we will use Microsoft Excel 365.
This article will demonstrate how to use the IMSUB function in Excel to determine the difference between two imaginary numbers and imaginary and real numbers by using the IMSUB function and combining the IMSUB and COMPLEX functions in Excel. In the following image, we will show the differences between two complex numbers by using the general subtraction formula.
Example 1: Applying the IMSUB Function to Find the Difference Between Two Complex Numbers in Excel
Here, we will create a sample data set including 1st complex number and 2nd complex number column for applying the IMSUB function to determine the difference between two complex numbers.
Steps:
- Firstly, choose the D5 cell.
- Secondly, write down the following formula here.
=IMSUB(B5,C5)
- Thirdly, press Enter.
- Therefore, you will see the difference between two complex numbers for the D5 cell. To find all the results, use the Fill Handle tool and drag it down from the D5 cell to the D10 cell.
- Finally, you will get all the results here in the below image.
Example 2: Combining IMSUB and COMPLEX Functions to Determine the Difference Between Two Complex Numbers
In this section, we will combine the IMSUB and COMPLEX functions to find the differences between two complex numbers. So, to know this, you can follow the below steps accordingly.
Steps:
- Firstly, select the D5 cell.
- Then, write down the following formula here.
=IMSUB(COMPLEX(B5,C5),$F$5)
- After that, press Enter.
- COMPLEX(B5,C5): This argument returns the complex number 5+i in the D5 cell.
- =IMSUB(COMPLEX(B5,C5),$F$5): This final function represents the difference between two complex numbers in the D5 cell which is 4.
- Besides, you will difference between two complex numbers for the D5 To find all the results, use the Fill Handle tool and drag it down from the D5 cell to the D10 cell.
- Lastly, you will get the final output where we have calculated all the differences between two complex numbers.
Download Practice Workbook
You may download the following Excel workbook for better understanding and practice it by yourself.
Conclusion
In this article, we’ve covered 2 suitable examples of how to use the IMSUB function in Excel. We sincerely hope you enjoyed and learned a lot from this article.