1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Adding a Formula to Calculate Total Income

By

Basic Excel 2010 Ecourse Tutorial Step 4
Adding Formulas in Excel

Adding Formulas in Excel

© Ted French

Adding a Formula to Calculate Total Income

Related Tutorial: Excel Formulas Overview

The Total Income formula will add an employee's Yearly Salary to his Bonus.

Tutorial Steps:

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

  1. If necessary, open the worksheet saved in the previous step of the tutorial.

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

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

  4. Click on cell B8 to enter that cell reference into the formula.

  5. Type a plus sign ( + ), since we are adding the two amounts.

  6. Click on cell C8 to enter that cell reference into the formula.

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

  8. The answer 50367.9 should appear in cell D8.

  9. When you click on cell D8 the formula = B8 + C8 should be visible in the formula bar above the worksheet.

  10. We will copy this formula to cells C9 to C11 in a later step in the tutorial.

  11. Save your worksheet.

©2014 About.com. All rights reserved.