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

Get FREE Advanced Excel Exercises with Solutions!

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.

Suitable Examples to Use IMSUB Function in Excel


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.

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

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

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.


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.


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo