Hi Sandra

With Vat rate in A1 as a percentage e.g 17.5% for Standard or 5% for
Lower
If you want to go from Gross figure to Net of VAT figure, then with
Gross in B1
=B1/(1+A1)
If you want to Know the amount of VAT contained within the Gross figure
then
=B1-(B1/(1+A1))

If you are going from Net of VAT figure to Gross, then
=B1*(1+A1)



--
Regards

Roger Govier


"Sandra" wrote in message
...
I would like to be able to set up a template for my vat returns each
month,
using the correct formulas for total, standard and vat. Can you please
help