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.
Download Practice Workbook
You may download the following Excel workbook for better understanding and practice it by yourself.
Introduction to IMSUB Function
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.
2 Suitable Examples to Use IMSUB Function in Excel
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 IMSUB Function to Find 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 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.
Read More: How to Add Complex Numbers in Excel (With Easy Steps)
Example 2: Combining IMSUB and COMPLEX Functions to Determine 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.
Read More: How to Use Excel IMSUM Function (4 Easy Examples)
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. Additionally, if you want to read more articles on Excel, you may visit our website, Exceldemy. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.
Related Articles
- How to Get Complex Number Magnitude in Excel (2 Easy Methods)
- Use Excel IMABS Function (5 Practical Examples)
- How to Use IMAGINARY Function in Excel (3 Examples)
- Use IMPRODUCT Function in Excel (4 Examples)
- How to Use IMDIV Function in Excel (3 Examples)
- Convert Complex Numbers to Polar Form in Excel