Use
=((A2*(1-20%)*(1+5%))*(1+2%))
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
Use
=((A2*(1-20%)*(1+5%))*(1+2%))
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 03:15 PM.
Bookmarks