Hi Rod

To add VAT use:

=A1*(1+18%)

To find net of VAT amount use:

=A1/(1+18%)

To find the VAT content

=A1-A1/(1+18%)


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Rod Hutton" <Rod wrote in message ...
I understand that many US people may use this forum more than the UK.....but
here goes...

I want to calculate the VAT element of an amount, for example:
£35,000 sales
@ 17.5%
amount less VAT is: £29,787.23p
VAT element is: £5,212.76p
I need a formula that just gives me the VAT element.

Many thanks US !!!

Rod