How to Update Prices in Excel by %

Solved/Closed
pgh - Dec 19, 2009 at 07:33 PM
 pgh - Dec 20, 2009 at 03:06 AM
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

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Dec 19, 2009 at 09:20 PM
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
Thanks, much appreciated. It is easy when you know how. :-)
0