How to Calculate Percentage Savings in Microsoft Excel

Found This Helpful

When items are on sale, it's often not until you get to the checkout before you discover just how much a 15 or 20 percent discount is saving you. With Microsoft Excel 2013, you can quickly calculate the savings on numerous items using any discount percentage.

Step 1:

Click the empty cell in Column B beneath the prices, which is also beside the word "Total." Click the "Formulas" tab and then click "Autosum" in the Ribbon. Press "Enter." The Autosum formula adds all of the numbers in the column and gives you the total price of your items.

Screenshot courtesy of Microsoft.

Step 4:

Click the cell beneath the total in Column B to calculate the percentage savings. Type the following formula in the cell, replacing "B6" with the cell number containing your total and replacing ".15" with the percentage of your discount: *=SUM(B6) .15**

There are four aspects to this formula. a) The formula begins with =SUM. b) The cell number is placed in brackets, such as (B6). c) The asterisk represents a multiplication sign in Excel. d) The percentage is expressed as a decimal.

In our example, the total is in cell B6. The discount is 15 percent, so this is expressed as 0.15.

Calculate the total discounted price by subtracting

the discount from the total. Type the following formula, replacing "B6" with your total's cell number and "B7" with your discount cell number: =SUM(B6-B7)

Type two numbers in an Excel worksheet. For example, to calculate the increase in a savings account between two months, type one month's savings total in cell A3 and the next month's total in cell B3.

Screenshot courtesy of Microsoft.

Step 2:

Click on any cell in the worksheet where you want the percentage change to appear. The formula for this operation has two components. First, you need Excel to subtract the first number from the second number to find the difference between them. Secondly, Excel needs to divide this difference by the first value. For example, if your savings account went from $10,000 to $12,000 in one month, the difference is $2,000. Dividing $10,000 by $2,000 gives you the percentage difference of 20 percent.

Type the following formula in the cell and press "Enter," replacing "A3" with the cell containing your first value and "B3" with the cell containing your second number:

The "ABS" function is used in this formula in case the difference between the two values is a negative number. ABS converts a negative number to an absolute, or positive, number.

Screenshot courtesy of Microsoft.


Category: Forex

Similar articles: