How to Use IMSUB Function in Excel (2 Suitable Examples)

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.

Suitable Examples to Use IMSUB Function in Excel


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.

Applying IMSUB Function to Find Difference Between Two Complex Numbers in Excel

  • 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.

Combining IMSUB and COMPLEX Functions to Determine Difference Between Two Complex Numbers  in Excel

Formula Breakdown
  • 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

Bishawajit Chakraborty

Bishawajit Chakraborty

I'm Bishawajit Chakraborty. Hello. I graduated from Rajshahi University of Engineering & Technology (RUET) with a degree in Mechanical Engineering. I'm working with ExcelDemy as a Content Developer for Excel & VBA. You can visit our website, Exceldemy if you'd like to read my published articles on MS Excel and VBA.

We will be happy to hear your thoughts

Leave a reply

5 Excel Tips
You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo