deduct tax from a total

D

Deltaecho

I need to deduct tax from a calculated total , i.e.
Col A=Qty
col B- price of item
col C = sum of col a and b
col D should show the total less the tax, presently at 16%
thanks in adavance
 
B

Bob Phillips

=C2*100/116

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
J

JulieD

Hi

personally i'ld put the tax value in a cell of its own so that if it does
change you don't have to remember to edit your formulas - which are less
obvious than a cell with the label of tax (ie D1 could say Total Less Tas of
and E1 could have the 16% in it) then your formula could be
=C2*(1-$E$1)

Cheers
julieD
 
J

JulieD

of course, if you do change the figure in E1 you need to be aware that items
calculated at the old tax rate will change unless you select them and copy /
edit - paste special - values first

Cheers
JulieD
 
B

Bob Phillips

Personally, I create a workbook name of VAT with a value of 17.5% (VAT in
the UK, 16% for the OP) :). I even add it my template workbook.

Bob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top