| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
=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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to have total for filtered data?? | Excel Discussion (Misc queries) | |||
| keep a running total of my formula results after each (F9) | Excel Discussion (Misc queries) | |||
| Total remaining formula | Excel Worksheet Functions | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
| ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. | Excel Discussion (Misc queries) | |||
Linear Mode
