How do I increase a spread sheet by 10%

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I make a cell increase by 40% when a number is entered 2
how to display two spread sheets side by side 4
How do number columns first, then the rows in an excel footer? 1
Want to Increase Prices by Percent 19
spread sheet 2
I need a formula that will multiply #'s in column C by 25.37869% 2
how do I set up spread sheet for demographical data to get graph. 1
How do you convert 100- to -100 in excel? 3

Top