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. 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. For example, to subtract 2 and 5 from 15, apply the formula 15-2-5. It begins with the comparison operator equal to () followed by the first number, the minus sign, and the second number. Delete all values in the sheet after you have tried the different combinations. The subtraction formula in excel facilitates the subtraction of numbers, cells, percentages, dates, matrices, times, and so on. Now, try to change the multiplication ( ) to subtraction ( -) and dividing ( / ). I want the adjacent cell to either deduct 5 if the amount is less than 30 or deduct 10 if the amount is greater than 30. It allows you to add values to cells and make you do calculations on them. I am entering a dollar amount into one cell.

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. I have a basic problem and am looking for hopefully a simple answer. Read More: Subtraction Formula in Excel (7 ways)

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. B2 (1-C2) Since 100 is equal to 1, to deduct a specific percentage value from a number, we first calculate the deducted percentage value by subtracting the percentage value from 1, and then multiplying it with the number.

Here, cell C5 has the Total Revenue amount and cell D5 has the Total Expense amount.

Excel formulas subtraction