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