+5 votes
87 views
How to use the IMSUB function in Microsoft Excel

in Guides by (551k points)
reopened | 87 views

1 Answer

+3 votes
Best answer

How to use the IMSUB function in Microsoft Excel

It is not complicated to use the IMSUB function in Microsoft Excel , its purpose is to return the difference between two complex numbers. In this simple guide we are going to see how we can use this function..

How to use the IMSUB function in Microsoft Excel

The first thing we will have to do is start Microsoft Excel as usual, we will have to create a table or use a file that already contains the data that we want to use with the IMSUB function.

image

We are going to have to write the formula in the cell where we want to place the results "= IMSUB (A2, B2)" without the quotes and then press "Enter" to see the results in question..

image

If we have more than a single data, what we can do is click on the result and keep it, then we drag it down to see the rest of the results.

image

There are two more methods to use this function. One of these methods is to click the "FX" button at the top left of the Excel spreadsheet..

image

"Insert function" will appear and we will have to search for "IMSUB" among all the functions. For this we will have to select one of the categories in the drop-down list, here we will have to choose "Engineering". To continue, we will simply have to click on "Accept".

Now a dialog box called "Function Arguments" opens.

  • We will have to enter in the "Inumber1" cell A2 of the input box.
  • In the case of the input "Inumber2" we are going to enter cell B2.

After this we are going to click on "Accept".

image

The other method is to click on the "Formulas" tab and then we will have to click on the "More functions" button in the function library group. After this we will click on "Engineering" and select IMSUB from the drop-down menu.

The "Arguments Function" will appear in the dialog box and we can use it without problems.



by (3.5m points)
edited

Related questions

+4 votes
1 answer
asked Nov 11, 2022 in Guides by backtothefuture (551k points) | 48 views
+3 votes
1 answer
asked Nov 21, 2021 in Guides by backtothefuture (551k points) | 83 views
+5 votes
1 answer
+3 votes
1 answer
asked Mar 31, 2023 in Office by backtothefuture (551k points) | 61 views
Sponsored articles cost $40 per post. You can contact us via Feedback
10,634 questions
10,766 answers
510 comments
3 users