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.
|