How to work out discount rate in excel
Calculating the Discount Rate in Excel In Excel, you can solve for the discount rate a few ways: You can find the IRR, and use that as the discount rate, which causes NPV to equal zero. You can Calculate discount rate with formula in Excel 1. Type the original prices and sales prices into a worksheet as shown as below screenshot: 2. Select a blank cell, for instance, the Cell C2, type this formula = (B2-A2)/ABS (A2) 3. Select the formula range cells, in this case, select the range Finally, if you want to know the final cost of a product, simply subtract the amount of the discount from the initial amount: final value (with discount applied) = initial value - ((discount percentage * total value)/100) Other forms of calculating discount in Excel