How to Calculate Percentage Savings in Excel

Written by bill brown
  • Share
  • Tweet
  • Share
  • Email

Excel is a great tool for automating numerical tasks. It is as basic as arithmetic and as complex as amortisation. The program puts calculating tools to use, embedding math into the spreadsheet so the results of your calculations appear instantaneously. It does this with formulas. A formula or equation is typed right into a cell. The program performs the operation on the data you enter and shows the numerical result in your cell. Once you have the basic formula set, you can even copy that formula anywhere on the spreadsheet. This way, you can repeat the process as you need to, figuring many percentage savings at once.

Skill level:
Moderate

Other People Are Reading

Instructions

  1. 1

    Open a new Excel spreadsheet.

  2. 2

    Create a table to hold your data in the spreadsheet. Type "Item" in cell A1. Type "Original Price" in cell B1. Type "Discounted Price" in cell C1. Type "Savings" in cell D1. Type "Percentage Savings" in cell E1.

  3. 3

    Type "=B2-C2" in cell D2. This will calculate the price difference.

  4. 4

    Type "=D2/B2" in cell E2. This will figure your percentage savings.

  5. 5

    Click on the tab at the top of spreadsheet with the letter "E." This highlights the entire E column. Select "Format" from the top menu. Select "Cells." Click on "Percentage," then "OK."

  6. 6

    Enter your data. In cell A2, type the item's name. In cell B2, enter its original price. In cell C2, enter the discounted price. In cell D2, the cost savings appears. In cell E2, the percentage savings appears.

  7. 7

    Extend your table for more cost savings calculations. Go to cell D2. Select "Edit" from the top menu. Click "Copy." Click in cell D3 and drag downward in the D column, highlighting as many cells as you need for your data. Select "Edit" from the top menu bar. Click "Paste." This copies the formula into the cells. It does not copy specific data.

  8. 8

    Copy the percentage calculation. Go to cell E2. Select "Edit" from the top menu. Click "Copy." Click in cell E3 and drag downward in the E column, highlighting as many cells as you need for your data. Select "Edit" from the top menu bar. Click "Paste."

  9. 9

    Enter new data as you did previously.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.