deduct tax from a total

[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

 

[Bob Phillips]

=C2*100/116

--

HTH

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

 

[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

 

[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

 

[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