kascedrink.blogg.se

1. How to use microsoft excel to calculate percentage how to#
2. How to use microsoft excel to calculate percentage update#

In some times, you may want to merge two tables into one, and update the itmes and add new ones. See screenshot:Įasily merge two tables and update the new items in Excel Select a blank cell, for instance, the Cell C2, type this formula =A2-(B2*A2) (the Cell A2 indicates the original price, and the Cell B2 stands the discount rate of the item, you can change them as you need), press Enter button and drag the fill handle to fill the range you need, and the sales prices have been calculated.

If you have lists of data about the original prices and discount rate in a worksheet, and you can do as follow to calculate the sales prices. Tip: The result percentage reflect a percent discount on the item. There is an alternative method: firstly select the range, and then click the % (Percent style) in the Number group on the Home tab. In the Format Cells dialog, click Number > Percentage, and specify the decimal places then click OK. Select the formula range cells, in this case, select the range C2:C5, right click > Format Cells. Select a blank cell, for instance, the Cell C2, type this formula =(B2-A2)/ABS(A2) (the Cell A2 indicates the original price, B2 stands the sales price, you can change them as you need) into it, and press Enter button, and then drag the fill handle to fill this formula into the range you want. Type the original prices and sales prices into a worksheet as shown as below screenshot:Ģ. The following formula is to calculate the discount rate.ġ. If you want to follow along with this tutorial, please download the example spreadsheet. But if the different kinds of items have different discounts, how can you calculate the discount rates or prices of the different items? Now, I talk about two formulas for you to calculate the discount rates and discount prices in Excel.Ĭalculate discount rate with formula in ExcelĬalculate discount price with formula in Excel When Christmas is coming, there must be many sale promotions in shopping malls.

How to use microsoft excel to calculate percentage how to#

How to calculate discount rate or price in Excel?