Percentages on total with tax addition and discount deduction

[Anmol786]

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

[Bob Phillips]

Use

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

[Beamer]

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)