G Guest Jun 7, 2004 #1 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.
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 Jun 7, 2004 #2 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.
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.
