If you put the original price in cell A1, then the formula you insert into cell B1 or whichever other cell you wish to calculate the new value is:
=A1*(1-(30/100))
Chat with our AI personalities
The sale price is $156.00
Market price x's Karat percent. Then divide by 31.13 (troy ounce) Then that total is your full melt price. Then you divide that by 2 for your average price a pawn shop would pay you for it.
It is 100*(1 - Discounted price/Full price) or 100*Discount amount/Full price
Double price is equal to 200% of the original price.
Commission = percent x original price / 100 so original price = commission x 100 / percent