Step 1: Open a new Excel workbook and rename cell A1 as Employees Name, cell B1 as Gross Salary, cell C1 as Deductibles, and cell D1 as Net Pay. You can use the example below to practice subtraction using the cell referencing method in Excel. Subtraction exercise using cell referencing You can drag horizontally or vertically, depending on your data arrangement.
Step 5: Replicate the subtraction process by clicking and holding on the bottom right of the selected cell and dragging across adjacent cells to replicate the subtraction formula.
Select the cell referencing the figure to be subtracted and press the Enter key to complete the process. Enter the minus (-) symbol by pressing the (-) Hyphen key. Step 4: Enter the equals symbol (=) and click on the Reference Cell with the data that requires deducing. Step 3: Double click on the selected output cell and wait for the cursor to indicate readiness for data input. You can subtract data across a row or column arrangement. Step 2: Select the preferred cell for displaying the resulting difference. Save the Excel Workbook to ensure your work progress is secure. Step 1: You can open your Excel workbook and populate it with personal data.
You can follow the procedure below to perform a subtraction calculation in Excel.
