X

We Value Your Privacy

We and our partners use technology such as cookies on our site to personalise content and ads, provide social media features, and analyse our traffic. Click below to consent to the use of this technology across the web. You can change your mind and change your consent choices at anytime by returning to this site.

Update Consent
DISCOVER
×
Loading ...

How to Calculate Percentage Savings in Excel

Updated February 21, 2017

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.

Loading ...
  1. Open a new Excel spreadsheet.

  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. Type "=B2-C2" in cell D2. This will calculate the price difference.

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

  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. 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. 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. 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. Enter new data as you did previously.

Loading ...

About the Author

Bill Brown has been a freelance writer for more than 14 years. Focusing on trade journals covering construction and home topics, his work appears in online and print publications. Brown holds a Master of Arts in liberal arts from St. John's University and is currently based in Houston.

Loading ...