Adding an overall percentage to price list

  • Thread starter Thread starter Toni
  • Start date Start date
T

Toni

Hi, I have tables of price lists given to us by our
supplier all in Excel format. Our supplier has just
advised of a 2% price increase on all their products.
Can I increase the original price lists by 2% without
formatting each cell one-by-one?? At the moment, each
cell with a price in is formatted as a number with two
decimal places. Many thanks for any assistance.
 
Hi Toni!

Put 1.02 in an empty cell
Select that cell
Copy
Select the old prices
Edit > Paste Special > Multiply > OK

You might want to consider rounding your results rather than
formatting to two decimal places?
 
One way:

Enter 1.02 in an empty cell. Copy the cell. Select your prices. Choose
Edit/Paste Special, selecting the Values and Multiply radio buttons.
Click OK.
 
Back
Top