Percentage increase
I have a spreadsheet with 3 columns of figures. There is a price increase of
6% this year but I don't know how to use the existing spreadsheet and add the 6% to all 3 columns. -- Lynne Mawson Manchester |
Percentage increase
One way:
Put 1.06 in an empty cell. Copy the cell. Select the values in the three columns. Choose Edit/Paste Special, selecting the Values and Multiply radio buttons. Click OK. In article , Lynne Mawson wrote: I have a spreadsheet with 3 columns of figures. There is a price increase of 6% this year but I don't know how to use the existing spreadsheet and add the 6% to all 3 columns. |
Percentage increase
GE McGimpsey - you are a star! Saved me hours of messing around. Thanks.
-- Lynne Mawson Manchester "JE McGimpsey" wrote: One way: Put 1.06 in an empty cell. Copy the cell. Select the values in the three columns. Choose Edit/Paste Special, selecting the Values and Multiply radio buttons. Click OK. In article , Lynne Mawson wrote: I have a spreadsheet with 3 columns of figures. There is a price increase of 6% this year but I don't know how to use the existing spreadsheet and add the 6% to all 3 columns. |
All times are GMT +1. The time now is 01:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com