Results 1 to 3 of 3

Thread: Percentages on total with tax addition and discount deduction

  1. #1

    Percentages on total with tax addition and discount deduction



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Sirs
    (Following is just a specimen only)


    I have an article worth 10,000 Rs.
    i want to give 20% on it but want to add 5% sales tax on it
    then i want to add 2% excise duty on it
    How is it possible in excel throu one formula
    plz give solution


    in only one formula

  2. #2
    Use

    =((A2*(1-20%)*(1+5%))*(1+2%))

  3. #3
    Or just =A2*0.8*1.05*1.02

    But if you have lots of cells to do this to, like a price list, I would separate your taxes and discounts into their own cells.
    That way if you decide to change your discount, or 1 of the taxes change, then you would only need to change that 1 cell.

    E.g.

    Cell A1 Discount
    Cell A2 Sales Tax
    Cell A3 Excise Duty

    Cell B1 20%
    Cell B2 5%
    Cell B3 2%

    then in required cell =10,000*(1-B1)*(1+B2)*(1+B3)
    Last edited by Beamer; 2014-12-06 at 02:15 PM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •