Formula to find out the discount value. Select a blank cell for. Type the original prices and sales prices into a worksheet as shown as below screenshot.
Large Discount ListPrice-SellingPrice Therefore large SellingPriceListPrice-Discount large.
From the formula above you need the discount amount and the original price. Converting 020 to a percent. YX P X is 60 Y is 12 so the equation is 1260 P Do the math. I am trying to find out the discount amount of a price.