Can I use Excel to calculate VAT?

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

Guest

I'm a very new user of Office and have very little clue of whether or not
such things are possible. Any help would be much appreciated.
 
Exactly how you do it depends on your tax laws but these formulae should
get you going. In each case I have assumed the starting data is in A1
and the VAT percentage is in B1

Calculate VAT to be added to a base price
=ROUND(A1*B1/100,2)

Calculate selling price from base price
=ROUND(A1*(100+B1)/100,2)

Calculate Base price from retail price
=ROUND(A1*100/(100+B1),2)

Depending on accounting rules you may need to use Roundup or Rounddown
to get the right figure
 
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

vat adds up correctly accross spreadsheet but down the columns whe 5
VAT on Report 5
historic VAT Rate lookup 10
New VAT Rate 2
Variable VAT by product and customer 2
Validation of UK VAT Number 20
How to Migrate IMAP Email to Office 365 Easily 0
Amount minus VAT 6

Back
Top