Best Math Formula website. Search anything about Math Formula in this website.
what is the formula for discount percentage in excel. The following formula is to calculate the discount rate. On the Home tab in the Number group click the percentage symbol to apply a Percentage format.
Excel Formula To Add Percentage Markup Excel Formula Excel Excel Hacks from www.pinterest.com
Multiply this result by the original price. If you have a discounted price and know the discount percentage you can calculate the original price with a simple formula that divides the discounted price by the result of 1 minus the discount percentage. The formula will appear as B233.
To understand the formula in terms of cells where the percentage is placed in cell A1 and the price in cell A2.
Place your cursor on the cell say cell A7 where you want the answer to be displayed. The following formula is to calculate the discount rate. The new result is multiplied by the price to get the price after the discount. The basic formula for calculating a percentage is parttotal.
