Wednesday, 20 June 2012

Excel Subtraction Formula

To subtract one value from another, you just use the minus sign in between your cell references. Like this:

= A1 - A2


Below is an image from a spreadsheet showing a subtraction formula:

Subtraction Formula


Cell A3 is where the answer is displayed, and where we entered the formula.


If you want to subtract more than two cells you can do it like this:

= A1 - B1 - C1


Subtraction is fairly straightforward in spreadsheets, and shouldn't cause you too many problems.

No comments:

Post a Comment