deduct tax from a total
 

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

=C2*100/116

--

HTH

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


"Deltaecho" wrote in message
...
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


"Deltaecho" wrote in message
...
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

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

"JulieD" wrote in message
...
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


"Deltaecho" wrote in message
...
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

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


"JulieD" wrote in message
...
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

"JulieD" wrote in message
...
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


"Deltaecho" wrote in message
...
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