PDA

View Full Version : Percentage calculation in excel


Basheeruchil
Nov 17, 2017, 07:19 AM
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

abdulkadir1
Nov 18, 2017, 09:11 PM
Original Amount * (1-(Percent Discount)/100) = Desired answer

donf
Dec 4, 2017, 04:35 AM
(Sale Price / Orig. Price) * 100 = Percentage Off

(3500/5000) * 100 = Percentage Off

0.7 *100 = 70%

Proof 5000 * 70% = 3500