And please visit our website ExcelDemy to explore more.

Create a Formula to Subtract Multiple Cells From One Cell 3.1 Subtract Using Minus Sign 3. Use Cell Reference to Create Subtraction Formula in Excel 3. Input Numbers Directly on Excel Subtraction Formula 2. We will try to respond to all the relevant queries asap. Download Practice Workbook 10 Ways to Create a Formula to Subtract in Excel 1. 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. 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. Read More: Subtraction Formula in Excel (7 ways) So, you have successfully subtracted the Total Expense from the Total Revenue using the SUM function. You do a similar calculation when you multiply the unit price by the quantity and get the total inventory for that item.

The subtraction sign is denoted by the dash ( - ). ❸ Drag the Fill Handle icon from cell E5 to E12. You could easily show the subtraction of Col H from Col C in a single column to the right called 'balance' or something, and each line would resolve to the balance of that item code (in col A). The basic subtraction formula is (cell location) - (cell location). Here, cell C5 has the Total Revenue amount and cell D5 has the Total Expense amount. Another way to add years to a date is with the YEAR, MONTH, DAY and DATE Functions: DATE(YEAR(B3),(123+MONTH(B3)),DAY(B3)) The DATE Function creates a date using a specified Year, Month, and Day.

Excel formulas to subtract