hts-direct Posted February 12, 2005 Share Posted February 12, 2005 hi - is there anyway i can add a percentage to a list of prices with exel? been trying to find a way to do this for a while, any help would be brilliant. thankyou, ashley Link to comment Share on other sites More sharing options...
Jack_mcs Posted February 12, 2005 Share Posted February 12, 2005 Here's what you do: - Type the percentage you want to use in some empty cell (typing 1.5 will raise it by 50%) - Select that cell and copy it (ctrl c) - Highlight the columns (or cells) you want to increase - Select the menu item Edit->Paste Special. Click on the values and multiply buttons and OK That should do it. Jack Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
hts-direct Posted February 12, 2005 Author Share Posted February 12, 2005 thankyou for your help jack i'll try that in a sec. Ash Link to comment Share on other sites More sharing options...
hts-direct Posted February 12, 2005 Author Share Posted February 12, 2005 hi jack ive tried that method with 0.3 (10%) i think, but it seemed to take the prices down. ash Link to comment Share on other sites More sharing options...
Jack_mcs Posted February 12, 2005 Share Posted February 12, 2005 Yes, that would. 10% would be 1.1. Jack Support Links: For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Flyer5 Posted February 12, 2005 Share Posted February 12, 2005 Ive made you an excel workbook that will do it all for you. Its user friendly too - almost a first for me! PM me your email address and Ill mail it to you. Regards F5 Link to comment Share on other sites More sharing options...
Flyer5 Posted February 12, 2005 Share Posted February 12, 2005 Its in your mailbox (hopefully - it was a hotmail address, not sure what size file they allow) If it failed you can open a web page by Clicking here and download it. regards Gav Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.