How To Subtract in Excel With a Formula



※ Download: What is the subtraction formula in excel

This can be either a cell location, or a numerical value. All you need to apply is the subtraction formula using subtraction operator. For example, subtract a range of numbers, by typing SUM A1:A4 or SUM A1,A2,A3,A4.


Similarly like addition, subtraction of numbers together is very easy. What kind of things can you subtract in your worksheets? You will find that the answer in column C will automatically get changed. Let's say you want to find out how many inventory items are unprofitable subtract profitable items from total inventory.


How To Subtract in Excel With a Formula - Or, click the Show Formulas button on the Formulas tab. How to subtract in Excel?


Recommended Productivity Tools Subtract a number from a range of cells with Paste Special function With this method, you can do as the following steps: 1. Insert the number 99 into a blank cell and copy it. In the Paste Special dialog box, select All option in the Paste section, check Subtract option in the Operation section, and click the OK button. See screenshot above: The specified number 99 has been subtracted from the range of cells. And then delete the number 99. Subtract a number from a range of cells with a Formula Here a simple formula also can help you. Take the above data for example: 1. Keep the Cell C1 selected, and drag its AutoFill handle to the range as you need. And then all cells are extracted 99. As calculating results are formulas, you can copy these formulas cells, select a blank cell, right click and select the Values V to replace the formulas with their calculated results. See screenshot: Batch subtract a number from a range of cells without formula With Kutools for Excel, you can not only apply the add, subtract, multiply, divide operation, but also can apply some complex calculation, such as rounding, exponentiation, custom expression or function operation. In the Operation Tools dialog box, select Subtraction from Operation, input the number 99 in the Operand box, and then click OK or Apply. And then the range of cells will be subtracted by the number 99. See screenshot: Note: If you want to create formulas as well, you can check Create formulas option. Kutools for Excel includes more than 120 handy Excel tools. Free to try with no limitation in 30 days. Related articles: Recommended Productivity Tools Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer. Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day! I have a number like 500 and i have a tall list like , 20, 10, 50, 70, 90 and i will input in more data as when items are requested. A requested 50 today so the difference now will be 450. B also request 50 tomorrow i want excel to automatically deduct it from the stock of 500 and give me 400.

 


Excel does not have a specific SUBTRACT function. You can perform subtraction in different ways: Subtraction between simple numbers For this, you can use a single cell on which you can perform subtraction problems. As the result, the unique values in the larger list are labeled accordingly: And now, you can the unique values and copy them wherever you want. I thank you for reading and hope to see you on our blog next week. This can be either a cell location, or a numerical value. See screenshot: Batch subtract a number from a range of cells without formula With Kutools for Excel, you can not only apply the add, subtract, multiply, divide operation, but also can apply some complex calculation, such as rounding, exponentiation, custom expression or function operation. For example, subtract a range of numbers, by typing SUM A1:A4 or SUM A1,A2,A3,A4.