![]() ➤ First of all, we will type the following formula in cell I5, and press ENTER. Here, we will use the SUM function in the Savings column to subtract multiple cells from the Salary column. Read More: Subtraction for Whole Column in Excel (with 5 Examples) ➤ After that, we will select the cells in the Salary column from D5 to D12, and we will right-click.įinally, we can see that the salary column contains cell values that subtract $300 from them. ![]() ➤ First of all, we will right-click on cell I5. ![]() ![]() In this method, using a paste special feature we will subtract the value in cell I5, which is $300 in the Health Insurance column from the Salary column cells. Method-2: Paste Special Feature to Subtract Single Cell from Multiple Cells Read More: How to Subtract Columns in Excel (6 Easy Methods) ➤ We will drag down the formula with the Fill Handle tool.įinally, we can see all the savings in the Savings column. D5-E5-F5-G5 → Subtracts cells E5, F5, G5 from cell D5.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |