How to Update Prices in Excel by % Solved/Closed

Question

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.

venkat1926 · Answer

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.

How to Update Prices in Excel by %

1 response

Subscribe To Our Newsletter!