LinkBack URL
About LinkBacks
Hello, I'm using a csv file from a wholesale company and need to increase my prices by 50%. Thanks in advance for your help.
Hello, I'm using a csv file from a wholesale company and need to increase my prices by 50%. Thanks in advance for your help.
Try =A1*1.5
should do it.
EDIT: assumes your price is in A1, click and drag down for increases.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
other idea:
in empty cell write 1.5
copy (Ctrl+C) that cell
select all cells with prices
In the main ribbon under pase you will find small triangle - click it to see Paste Special and click on Paste Special to see dialog window.
Select "Multiply" and click OK
PS. If you use Sambo kid approach, it is probably good idea to use a bit more elaborate formula:
This way you will have prices with no more than 2 decimal places.
Please Login or Register to view this content.
Otherwise with original price of 10.99 you would get 16.485
You can use any unused cell in the top row for the % to be increased increased. for eg: if you data has 4 columns then you can use the 5th column ie E1 and type 50%.
and suppose your cost is in A2 then type the formula in E2 like =A2+(A2*$E$1) and copy the formula down. In this case you can change the value in E1 always and you will get the new price without changing the formula.
HTH
Appreciate clicking the * Add Reputation button on your left side, if you want say thanks to me
Hi i want to creat a list of few names so that when i enter one name and scroll down the list automatically displayed...as in the case of days or numbers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks