Formulas

[CAF]

What formula would I use to work out VAT on Invoices, purchases etc. It was quite simple on 2000, but will not work on 2003. If anybody knows, please tell me.

 

[Peo Sjoblom]

There is no difference, if you have a value that you want the VAT for

=Cell_with_Value*0.175

if you want the total price VAT included

=ROUND(Cell_with_Value*1.175,2)

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

What formula would I use to work out VAT on Invoices, purchases etc. It

was quite simple on 2000, but will not work on 2003. If anybody knows,
please tell me.