If the pre-VAT price is in A1, then the VAT is computed with =A1*17%
(change 17% to your value)
To compute the with-VAT price use =A1*(1+17%)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"JCS" wrote in message
...
Hi
I am trying to add VAT to a column in my spreadsheet but it doesn't seem
to
like the funcion i type in, can anyone help.