How do I increase a spread sheet by 10%

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

Guest

I Am doing a spread sheet, I have completed it they are for four years - I
need to increase the last three years each by 10% - anyone know what I do or
the formular?
Thanks
 
Joni

Enter 1.1 in an unused cell.

Copy that cell.

Select your range of numbers for the three years and Edit>Paste Special(in
place)>Multiply>OK>Esc.

Clear the cell with 1.1


Gord Dibben MS Excel MVP
 
Back
Top