Vat Calculator

  • Thread starter Thread starter pdboyle
  • Start date Start date
P

pdboyle

Does anyone know were, or do they have an example of a simple progra
for calculating VAT using Excel
 
Hi
if A1 stores the value without VAT and B1 the VAT percentage try
1. Calculate the VAT amound:
=A1*B1

2. Calculate the amount incl. VAT:
=A1*(1+B1)
 
You must log in or register to reply here.

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

Access Query problem 1
New VAT Rate 2
Macro Active Page Name 7
historic VAT Rate lookup 10
Expression in a report 10
Validation of UK VAT Number 20
Variable VAT by product and customer 2
VAT on Report 5

Back
Top