1. To further expand the reach of our Marketplace and increase potential buyers, we have created two social accounts solely for the promotion of our Marketplace. Check it out here! Don't forget to follow our pages!
  2. We would like to know you better hence we made the the introductions more interesting. Would love to see you answer the questions here!
  3. The winners for the TWF Annual Survey Draw have been revealed! Are you one of them? Check the list of winners here.

Creating a VAT formula in Excel

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

Image has been removed.
This URL has been automatically filtered because it has been posted by a new member. Active URLs posted by new members are always filtered. Once members have 10 or more posts and have been registered for 10 or more days, this filtering will be removed. To post URLs within the restriction period, just remove the http:// section which makes the URL non-clickable (i.e. website.com).
This email address has been automatically filtered because it has been posted by a new member. Active email addresses posted by new members are always filtered. Once members have 10 or more posts and have been registered for 10 or more days, this filtering will be removed.
Media has been removed.
  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:
    524
    Re: VAT and Excel

    row by row?
  3. Saajan

    Saajan

    Joined:
    Oct 30, 2005
    Messages:
    10,736
    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:
    524
    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:
    650
    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:
    650
    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,624
    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:
    650
    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