In this video we discuss how to subtract cells in a spreadsheet in excel. We go through a couple of examples including results that are negative and subtracting cells that are not in the same column or row.
Transcript/notes (partial)
In this excel spreadsheet we have values in cells a1 thru a3, and let’s say that we want to subtract cells a2 and a3 from cell a1 and put the answer in cell b4.
We start by left clicking on cell b4, so it is highlighted, then we type in the equals sign, next we left click on the cell we are subtracting from, in this case cell a1, then we type in a minus sign, next, we left click on the first cell we are subtracting, cell a2, then we type in another minus sign. And then we left click on the next cell we are subtracting, cell a3. Next we finish by hitting the enter sign and we get an answer of 34.
And a couple of other types of examples. It is possible to get negative answers in cells, as you see in this example.
Timestamps
0:00 How to subtract cells in excel
0:35 Other types of examples of subtracting cells in excel
