Formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working out VAT owed 1
Excel Formula 2
Please help - formula for percentage 2
Access Query problem 1
copying formulas 7
Lookup function help please 9
Calculating VAT at different rates 6
how to add 17.5% vat formula 7

Back
Top