Percentage increase

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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