If you used the example numbers, the result is -2. Subtracting Cells/Values in Excel Select the cell where you want to subtract and enter an equal to sign () Enter the first value Enter the subtraction sign. You can enter the cell references directly, which you want to subtract directly into the formula, i.e. Excel has a useful feature called Formulas that allow you to do both basic math, such as addition and subtraction, or more complex items like finding averages, or even building your own formulas. If you don't see the status bar, on the View menu, click Status Bar. On the status bar, look at the value next to Sum=. If you see a date instead of the result that you expected, select the cell, and then on the Home tab, under Number, click General on the pop-up menu. If you used the example numbers, the result is 2. In cell E1, type an equal sign ( =) to start the formula. When you use cell references in a formula instead of the cell value, you can change the value without having to change the formula. If you use the example numbers, the result is 32.Ī cell reference combines the column letter and row number, such as A1 or F345. The total is 86.Ĭlick any blank cell, and then type an equal sign ( =) to start a formula.Īfter the equal sign, type a few numbers that are separated by a minus sign (-). On the status bar, look at the value next to Sum. Type a few numbers in a column, or in a row, and then select the range of cells that you just filled. If you see a date instead of the result that you expected, select the cell, and then on the Home tab, select General. Step 2: Place the cursor in the cell where you want the result to appear (we use cell B5). For example, to reduce the number 130 from the number. Continue reading below for more information on subtracting in Excel, as well as view pictures of these steps. This is true in writing any excel formula. Enter the first cell value, then a - symbol, then the second cell value. Please check out this link to learn more about IF function. Otherwise, return the value of cell A2 as it is.
IF (A2>0,B2-C2,A2) The above formula says: IF cell A2 greater than 0, then subtract cell C2 from B2 and return the result. Its just that at the beginning of the formula you must give an equal sign (), this is a sign that what we are writing is an excel formula / formula. Let me show you a simple example as follows.
#EXCEL SUBTRACTION FORMULA HOW TO#
Note: In our case, we want to subtract 125, 18, and 5 from 989. How to use the subtraction formula in Excel is quite simple, like writing a subtraction problem. Step 1: Open a Microsoft Excel document and enter numbers to perform subtraction. RE: Excel subtraction formula KenWright (TechnicalUser) 24 Aug 03 11:06 Are the values in C2,D2,E2,F2 cumulative, ie if you spent a total of 50K in Q1 then cell C2 would have 50K, and if you spent a further total of 30K in Q2 would cell D2 then be 80K. If you change the value of C1 or D1 and then press RETURN, the value of E1 will change, even though the formula did not. Steps to perform two or more numbers subtraction.
0 kommentar(er)
