Guest Posted January 12, 2008 Share Posted January 12, 2008 Hi all Sorry if this is in the wrong place, mods feel free to move. I have generated a froogle file using easy populate but it is showing net price and not the price with vat added Any one know how to add VAT 17.5% to price columb. I am using excel I am using a formula of =D1*1.175 in a columb next to the price and this produces the price with vat but what I want to do is merge the 2 columbs so it only shows the price with the VAT included. Thanks in advance Liam Link to comment Share on other sites More sharing options...
Guest Posted January 12, 2008 Share Posted January 12, 2008 Hi all Sorry if this is in the wrong place, mods feel free to move. I have generated a froogle file using easy populate but it is showing net price and not the price with vat added Any one know how to add VAT 17.5% to price columb. I am using excel I am using a formula of =D1*1.175 in a columb next to the price and this produces the price with vat but what I want to do is merge the 2 columbs so it only shows the price with the VAT included. Thanks in advance Liam Problem solved within easy populate Regards Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted January 12, 2008 Share Posted January 12, 2008 Click on the title letter of the inc vat column to select the column press ctrl and the n C to copy the column. Then click on Edit > Paste Special > Values > OK Then delete the excl vat column. Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Link to comment Share on other sites More sharing options...
Guest Posted January 12, 2008 Share Posted January 12, 2008 Click on the title letter of the inc vat column to select the column press ctrl and the n C to copy the column. Then click on Edit > Paste Special > Values > OK Then delete the excl vat column. Thanks M8 Much appreciated Sligoman Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.