How to use IMSUB formula in Excel

The Excel IMSUB operate is an Engineering operate and its function is to return the distinction between two advanced numbers. The formula for the IMSUB operate is IMSUB(inumber1, inumber2). The syntax for the IMSUB operate is below-

• Inumber1: The advanced quantity to subtract from which to subtract inumber2. It’s required.
• Inumber2: The advanced quantity to subtract from inumber1. It’s required.

How to use Excel IMSUB formula

The IMSUB formula is kind of easy; as soon as you realize the formula, On this tutorial, we’ll clarify how to use the IMSUB operate in Excel.

To use the IMSUB operate in Excel. Observe the steps under.

1. Launch Microsoft Excel
2. Create a desk or use an present desk out of your recordsdata
3. Place the formula into the cell you need to see the consequence
4. Press the enter Key

Launch Microsoft Excel.

Create a desk or use an present desk out of your recordsdata.

Kind the formula into the cell you need to place the consequence =IMSUB(A2, B2).

Press enter to see the consequence.

You probably have a couple of knowledge in the desk, you’ll be able to click on the consequence and drag the fill deal with down to see extra outcomes.

There are two different strategies to use the IMSUB operate

Technique one is to click on the fx button on the highest left of the Excel worksheet.

An Insert Perform dialog field will seem.

Contained in the dialog field in the part, Choose a Class, choose Engineering from the listing field.

Within the part Choose a Perform, select the IMSUB operate from the listing.

Then click on OK.

A Perform Arguments dialog field will open.

Within the Inumber1 entry field, enter into the entry field cell A2.

Within the Inumber2 entry field, enter into the entry field cell B2.

Then click on OK.

Technique two is to click on the Formulation tab, click on the Extra capabilities button in the Perform Library group.

Then click on Engineering and choose IMSUB  from the drop-down menu.

A Perform Arguments dialog field will seem.

We hope this tutorial helps you perceive how to use the IMSUB operate in Microsoft Excel.