Basic Excel Formulas Tutorial

By Ted French, About.com Guide

Adding a Formula to Calculate Net Salary

The Net Salary formula will subtract an employee's Deduction amount calculated in the previous step from the employee's Gross Salary.

Tutorial Steps:

For help on these steps, refer to the image above.

1. Click on cell F8 - the location where we want the formula's answer to appear.


2. Type an equal sign ( = ) to let Excel know that we are creating a formula.


3. Click on cell D8 to enter that cell reference into the formula.


4. Type a minus sign ( - ), since we are subtracting two amounts.


5. Click on cell E8 to enter that cell reference into the formula.


6. Press the ENTER key on the keyboard to complete the formula.


7. The answer 47345.83 should appear in cell F8.


8. When you click on cell F8 the formula = D8 - E8 should be visible in the formula bar above the worksheet.


9. Save your worksheet.

Completing the Tutorial

At this point you can choose to:

1. Carry on with part 2 of this tutorial which covers basic formatting options in Excel 2010, or


2. End this tutorial by completing the last step which involves copying the formulas in row 8 to rows 9 to 11 using the fill handle

Return to Index page

Previous

• Working with Data, Formulas, and Functions
• Data Entry in Excel
• Insert Rows to the Worksheet
• Using the TODAY Function to Add the Current Date
• Adding a Formula to Calculate Total Income
• Using a Named Range in Excel Formulas
• Adding the Employee Deductions Formula
• Adding the Net Salary Formula
• Copying Formulas with the Fill Handle

Next