Subtraction in Excel

December 8, 2021
228 Views 0

Graphic skills

There are two methods for you. Here we take this sales table as an example. How can we work out the net margins of each kind of fruit quickly?

 

· Option 1

Input the formula =C2-B2 and press Enter on the keyboard. Then drag the mouse to fill the following cells.

Subtraction in Excel1.gif  

· Option 2

1. Click Formulas, and click Insert Function to pop up a dialog.

Subtraction in Excel2.gif 

2. Input IMSUB in the dialog and input C2 in Plural 1 and B2 in Plural 2. Then click OK and drag the mouse to fill the following cells.

Subtraction in Excel3.gif 

WPS office software could be compatible with Microsoft Office, and these training contents help students or home workers finish their work efficiently.

Was this helpful?