Writing the employee deductions formula
- Click on cell C9.
- Type in the formula = B9 * rate and press the Enter key on the keyboard.
Writing the net salary formula
- Click on cell D9.
- Type in the formula = B9 - C9 and press the Enter key on the keyboard.
- Additional formula information:
Excel 2007 Formulas Step by Step Tutorial
Copying the formulas in cells C9 and D9 to other cells
- Click on cell C9 again.
- Move the mouse pointer over the fill handle (a small black dot) in the bottom right corner of the active cell.
- When the pointer changes to a black "plus sign", click and hold down the left mouse button and drag the fill handle down to cell C12.
- Click on cell D9.
- Repeat steps 2 and 3 and drag the fill handle down to cell D12.
0 comments:
Post a Comment