How to Update Prices in Excel by %

[Solved/Closed]
Report
-
 pgh -
Hello,
I have a lengthy spreadsheet (Office 2007) with stocked items and their prices, the prices are simply entered in a cell when I created the spreadsheet, and now number well over 2000, so to save manually working out a price increase for each individual cell, how do I automatically increase all the prices by say 30%?

Thanks in advance for your kind assistance.

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
800
suppose your data (sample) is like this from A1 to A5
1
2
3
4
5

in B1(or any other empty cell in the same row) copy this formula
=A1+A1*30%
now copy B1 down

easy way of copying this is select B1 and take the cursor to bottom right of the cell where cursor turns into +
click this + then automatically B1 will be copied down provided there is no gap in the data.
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Thanks, much appreciated. It is easy when you know how. :-)

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!