Writing and Copying the Net Salary Formula
- Select cell D7 in the spreadsheet.
- Type = B7 - C7 in cell D7 to subtract the deductions from the gross salary.
- Press the ENTER key on the keyboard.
- Select cell D7 again
- Click on the fill handle in the bottom right corner of cell D7.
- Drag down with the mouse to cell D10 to copy the formula from D7 to cells D8 to D10.