Formulas

C

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.
 
P

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


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