Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Computers for Beginners (https://www.askmehelpdesk.com/forumdisplay.php?f=79)
-   -   Percentage calculation in excel (https://www.askmehelpdesk.com/showthread.php?t=835582)

  • Nov 17, 2017, 07:19 AM
    Basheeruchil
    Percentage calculation in excel
    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
  • Nov 18, 2017, 09:11 PM
    abdulkadir1
    Original Amount * (1-(Percent Discount)/100) = Desired answer
  • Dec 4, 2017, 04:35 AM
    donf
    (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:30 PM.