Subtraction in Excel
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.
· Option 2
1. Click Formulas, and click Insert Function to pop up a dialog.
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.