How to calculate percentage in excel.. for example if I buy phone rs 3500.. but actual price is 5000.. shopkeeper give 3500.. how many percentage he deducted..
Please answer me in excel formula
How to calculate percentage in excel.. for example if I buy phone rs 3500.. but actual price is 5000.. shopkeeper give 3500.. how many percentage he deducted..
Please answer me in excel formula
Original Amount * (1-(Percent Discount)/100) = Desired answer
(Sale Price / Orig. Price) * 100 = Percentage Off
(3500/5000) * 100 = Percentage Off
0.7 *100 = 70%
Proof 5000 * 70% = 3500
All times are GMT -7. The time now is 02:59 PM. |