The Excel IMSUB function is an Engineering function and its purpose is to return the difference between two complex numbers. The formula for the IMSUB function is IMSUB(inumber1, inumber2). The syntax for the IMSUB function is below-
- Inumber1: The complex number to subtract from which to subtract inumber2. It is required.
- Inumber2: The complex number to subtract from inumber1. It is required.
How to use Excel IMSUB formula
The IMSUB formula is quite simple; once you know the formula, In this tutorial, we will explain how to use the IMSUB function in Excel.
To use the IMSUB function in Excel. Follow the steps below.
- Launch Microsoft Excel
- Create a table or use an existing table from your files
- Place the formula into the cell you want to see the result
- Press the Enter key.
Launch Microsoft Excel.
Create a table or use an existing table from your files.
Type the formula into the cell you want to place the result =IMSUB(A2, B2).
Press enter to see the result.
If you have more than one data in the table, you can click the result and drag the fill handle down to see more results.
There are two other methods to use the IMSUB function
Method one is to click the fx button on the top left of the Excel worksheet.
An Insert Function dialog box will appear.
Inside the dialog box in the section, Select a Category, select Engineering from the list box.
In the section Select a Function, choose the IMSUB function from the list.
Then click OK.
A Function Arguments dialog box will open.
In the Inumber1 entry box, input into the entry box cell A2.
In the Inumber2 entry box, input into the entry box cell B2.
Then click OK.
Method two is to click the Formulas tab, click the More functions button in the Function Library group.
Then click Engineering and select IMSUB from the drop-down menu.
A Function Arguments dialog box will appear.
We hope this tutorial helps you understand how to use the IMSUB function in Microsoft Excel.
Read: How to use GSTEP function in Excel.
