Take the pre-sale price. Divide the original price by 100 and multiply it by 30. Take this new number away from the original one. The new number is your discounted value.
How do you calculate discount on MRP in Excel?
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.
How is INR discount calculated?
For example, you have a discount of Rs 300 on a shirt that costs Rs 1,500. The price after the discount is Rs 1,200. The discount percentage is: = 300/1500 = 20% (amount of discount/Cost of the shirt).
How do you calculate discount in accounting?
A sales discount equals the percentage discount times the outstanding invoice amount. The discounted invoice amount equals the outstanding invoice amount minus the sales discount. For example, the sales discount on an invoice of $1,000 that offers a 2 percent discount is $20, since 0.02 x $1,000 = $20.
How do you calculate a 25 discount?
Percent Off Price Formula
- Convert 25% to a decimal by dividing by 100: 25/100 = 0.25.
- Multiply list price by decimal percent: 130*0.25 = 32.50.
- Subtract discount amount from list price: 130 – 32.50 = 97.50.
- With the formula: 130 – (130*(25/100)) = 130 – (130*0.25) = 130 – 32.50 = 97.50.
- 25% off $130 is $97.50.
On what discount is calculated?
Calculate Discount from List Price and Sale Price. The discount is list price minus the sale price then divided by the list price and multiplied by 100 to get a percentage.