How to Calculate Savings Percentage in Excel: 3 Easy Methods

Method 1 – Utilizing Percent Style Button

Step 01: Calculate Fraction of Discount

Create a new column named Savings Percentage, as shown in the following image.

Utilizing Percent Style Button to calculate savings percentage in excel

Enter the following formula in cell E5.

=(C5-D5)/C5

Cell C5 refers to the cell of the Price column, and cell D5 indicates the cell of the Discounted Price column.

Press ENTER.

A fraction of the discount for Smartphone will be available on your worksheet.

Use the AutoFill option of Excel to get the rest of the outputs.

Step 02: Convert to Percentage Format

Select the cells of the “Savings Percentage” column.
Go to the Home tab from Ribbon.
Click on the Percentage Style option from the Number group.

You will have the savings percentages for various “Products” as marked in the following picture.

Method 2 – Applying Keyboard Shortcut

Steps:

Follow the procedures mentioned in Step 01 of the 1st method to get the following output.

Select the cells of the “Savings Percentage” column and press the keyboard shortcut CTRL + SHIFT + %.

Your savings percentages will be available as demonstrated in the image below.

Method 3 – Using Number Format Feature

Steps:

Follow the steps used in Step 01 of the 1st method and you will have the following outputs as marked below.

Select the cells of the “Savings Percentage” column and go to the Home tab.
Click on the Number Format option from the Number ribbon group.

The Format Cells dialogue box will open on your worksheet.

Note: You can also use the keyboard shortcut CTRL + 1 to open the Format Cells dialogue box directly.

In the Format Cells dialogue box, choose the Percentage option.
Add the number of decimal places you want in the percentage format by clicking the increase and decrease buttons.
Click OK.

You will have the savings percentage as demonstrated in the following picture.

How to Calculate Cost Percentage in Excel

Steps:

Use the following in cell D5.

=C5/SUM($C$5:$C$9)

Cell C5 refers to the cost of “Food” in January month, and the SUM function will return the summation of the range of cells $C$5:$C$9.