And please visit our website ExcelDemy to explore more. We will try to respond to all the relevant queries asap. And don’t hesitate to ask any questions in the comment section below. The basic Excel subtraction formula is as simple as this: number1 - number2 For example, to subtract 10 from 100, write the below equation and get 90 as the result: 100-10 To enter the formula in your worksheet, do the following: In a cell where you want the result to appear, type the equality sign ( ). You are recommended to download the practice workbook attached with this article and practice all the methods. To sum up, we have discussed 3 methods to subtract from a total in Excel. You will get an Excel sheet like the following screenshot, at the end of the provided Excel file where you can practice all the methods discussed in this article.
Here are the steps: Place the cursor in the subtraction number position (cell B1) Do a copy (CTRL+C) Make a range A1:A10, containing the numbers that will be subtracted. Read More: Subtraction Formula in Excel (7 ways) The solution to subtract several numbers with a number without using a formula is to use special paste. So, you have successfully subtracted the Total Expense from the Total Revenue using the SUM function. ❸ Drag the Fill Handle icon from cell E5 to E12. Here, cell C5 has the Total Revenue amount and cell D5 has the Total Expense amount.
