Writing and Copying the Deductions Formula
- Select cell C7 in the spreadsheet.
- Type = B7 * rate in cell C7 to multiply the deductions rate times the gross salary.
- Press the ENTER key on the keyboard.
- Select cell C7 again
- Click on the fill handle in the bottom right corner of cell C7.
- Drag down with the mouse to cell C10 to copy the formula from C7 to cells C8 to C10.
