The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80% 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 calculate discount rate or price in Excel?
0 kommentar(er)
