trying to set up a spreadsheet and final column must show vat content but
can't work it out

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" <(E-Mail Removed)> wrote in message
news:9E5CBBB2-6208-44EA-9ACB-(E-Mail Removed)...
> trying to set up a spreadsheet and final column must show vat content but
> can't work it out