deduct tax from a total

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
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
 
Back
Top