You can use the Subtraction Function to execute complex computation formulas in Excel. Using the subtraction function in complex formulas Drag down column D while still pressing the click button to replicate the formula in the cells below. Step 5: Click and hold on the bottom right corner on cell D2. Complete the subtraction formula by clicking and referencing cell C2 and pressing the Enter key to compute the Net Pay for the first employee. Step 4: Calculate the Net Pay of the first employee by typing the equals (=) sign in cell D2 and click on cell B2, and then typing the minus (-). Step 3: Select cell D2 to subtract deductibles from the gross salary of the first employee. Step 2: Populate the cells in columns A, B, and C with random and logical data. 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.

Excel spreadsheet subtraction formula