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)

--

Regards,

Peo Sjoblom

"josudare" wrote in message
...
trying to set up a spreadsheet and final column must show vat content but
can't work it out