G Guest Aug 17, 2007 #1 trying to set up a spreadsheet and final column must show vat content but can't work it out
P Peo Sjoblom Aug 17, 2007 #2 Assuming you have the total price in D2 then you can use =D2-D2/(1+17.5%) to get the VAT Since we are dealing with money you might want to add ROUND to it =ROUND(D2-D2/(1+17.5%),2)
Assuming you have the total price in D2 then you can use =D2-D2/(1+17.5%) to get the VAT Since we are dealing with money you might want to add ROUND to it =ROUND(D2-D2/(1+17.5%),2)
