1. We would like to know you better hence we made the introductions more interesting. Would love to see you answer the questions here!
  2. Take a look at our recent Guest Articles here about dropshipping, e-commerce & Amazon Vendor and more.

Creating a VAT formula in Excel

Discussion in 'Money, Accounts & Finance' started by Headbutts MA, Mar 3, 2010.

  1. Headbutts MA

    Headbutts MA

    Joined:
    Feb 26, 2010
    Messages:
    48
    Hi

    I need to create a formula to add VAT to a column in Excel.

    I need to add VAT @17.5% to the whole of colomn D

    How would I do this?

    Thanks
  2. TSP

    TSP

    Joined:
    Jun 30, 2009
    Messages:
    522
    Re: VAT and Excel

    row by row?
  3. Saajan

    Saajan

    Joined:
    Oct 30, 2005
    Messages:
    10,730
    Re: VAT and Excel

    Do you mean add VAT to each amount that has been entered in column D?
  4. TSP

    TSP

    Joined:
    Jun 30, 2009
    Messages:
    522
    Re: VAT and Excel

    Create Column "E" as follows

    =D1*1.175

    Then just drag down and D1 should change to D2 etc.
  5. andy v001

    andy v001

    Joined:
    Jan 4, 2010
    Messages:
    647
    Re: VAT and Excel

    or, if you are trying to find out how much VAT you have to charge/pay (as opposed to the total amount, as in the example above by TSP), simply change the formula that TSP gave you to =D1*0.175

    This shows the VAT by itself
  6. Headbutts MA

    Headbutts MA

    Joined:
    Feb 26, 2010
    Messages:
    48
    Re: VAT and Excel

    OK, I think I need an idiots guide

    Col D2 through to col D775 is price without VAT
    I want col E2 through to E775 to have the total of col D with VAT.

    Do I press the funny E symbol or the = symbol ? followed by what equation?

    This is the first time I have used excel, so please bear with me :)
  7. Headbutts MA

    Headbutts MA

    Joined:
    Feb 26, 2010
    Messages:
    48
    Re: VAT and Excel

    1 sec
    May have sorted it :)
  8. Headbutts MA

    Headbutts MA

    Joined:
    Feb 26, 2010
    Messages:
    48
    Re: VAT and Excel

    Im half way there.

    I have entered the formula and got it to work so that the figure in D2 has VAT added in E2.

    How do I apply that formula to all 776 cells of D2 and E2?

    Thanks for the help so far.
  9. andy v001

    andy v001

    Joined:
    Jan 4, 2010
    Messages:
    647
    Re: VAT and Excel

    To make the formula expand to fit 776 cells of column D, click on D2. In the bottom right of cell D2, there is a small square. Click and drag it all the way to D775. Do the same for column E
  10. darren1979

    darren1979

    Joined:
    Feb 25, 2008
    Messages:
    1,630
    Re: VAT and Excel

    Just go to the colum with the formula in and hover the cursor until it changes to a little plus sign then just drag it down and it will autofill the colum.
  11. Headbutts MA

    Headbutts MA

    Joined:
    Feb 26, 2010
    Messages:
    48
    Re: VAT and Excel

    Ta Dah

    Thanks to all.
  12. andy v001

    andy v001

    Joined:
    Jan 4, 2010
    Messages:
    647
    Re: VAT and Excel

    No problemo :)

You must be a member to reply…

Why should you join us?

  • Networking Opportunities
  • Find Genuine Wholesalers
  • Source Profitable Stock
  • 100,000 Members Strong
Back to top

Share This Page