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