Subtraction in Excel
A free Office suite fully compatible with Microsoft Office
A free Office suite fully compatible with Microsoft Office
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.
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?
Yes
No
Trending Tutorials
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. Check if value is in list in Excel (3 easy methods)
- 3. How to Copy File Names in Excel from a Folder?
- 4. How to color cell based on value in Excel?
- 5. How to compare two excel sheets and highlight differences
- 6. How to add text to beginning or end of all cells in Excel