How To Subtract Values Or Numbers, And How To Subtract Cells In An Excel Spreadsheet Explained
1.6 هزار بار بازدید -
2 سال پیش
-
In this video we discuss
In this video we discuss how to subtract values, and how to subtract cells in an excel spreadsheet. We go through several examples from different situations
Transcript/notes
In excel, we can subtract cells or subtract actual values. Let’s start with subtracting actual values. For instance here is a blank spreadsheet, and lets say that we want to subtract 48 from 133, and put the answer in cell b3.
We start by left clicking on cell b3, so it is highlighted, then we type in the equals sign, next we type in the value we are subtracting from, in this case 133, then we type in a subtraction or minus sign, and then the value we are subtracting, 48. Next we finish by hitting the enter sign and we get an answer of 129.
And we can do this for more than 2 values as you see here is the subtraction of 3 numbers from a number.
Now for subtracting cells. Here we have values in cells a1 thru a3, (122,31,57) 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, and the cells you are subtracting do not need to be in the same column or row, as you see in this example, where I am subtracting cells e1, f3, and g2 from cell d4.
Chapters/Timestamps
0:00 How to subtract values or numbers in excel
0:33 How to subtract more than 2 numbers in excel
0:43 How to subtract cells in excel
1:24 How to subtract cells from different columns or rows in excel
Transcript/notes
In excel, we can subtract cells or subtract actual values. Let’s start with subtracting actual values. For instance here is a blank spreadsheet, and lets say that we want to subtract 48 from 133, and put the answer in cell b3.
We start by left clicking on cell b3, so it is highlighted, then we type in the equals sign, next we type in the value we are subtracting from, in this case 133, then we type in a subtraction or minus sign, and then the value we are subtracting, 48. Next we finish by hitting the enter sign and we get an answer of 129.
And we can do this for more than 2 values as you see here is the subtraction of 3 numbers from a number.
Now for subtracting cells. Here we have values in cells a1 thru a3, (122,31,57) 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, and the cells you are subtracting do not need to be in the same column or row, as you see in this example, where I am subtracting cells e1, f3, and g2 from cell d4.
Chapters/Timestamps
0:00 How to subtract values or numbers in excel
0:33 How to subtract more than 2 numbers in excel
0:43 How to subtract cells in excel
1:24 How to subtract cells from different columns or rows in excel
2 سال پیش
در تاریخ 1401/09/19 منتشر شده
است.
1,696
بـار بازدید شده