Add percentage to a cell

[Vicki_g]

I have never used Excel before. I need to calculate an increase to a range of
cells. How can I add 2.7% to a range of existing cells (b72-g85). I have
Excel 2003. Thank you.

 

[Gary''s Student]

1. enter 1.027 in an un-used cell
2. copy this cell
3. select cells B72 thru G85 and then:
Edit > PasteSpecial > Multiply > OK

 

[Vicki_g]

Thank you so much!!!!!!

1. enter 1.027 in an un-used cell
2. copy this cell
3. select cells B72 thru G85 and then:
Edit > PasteSpecial > Multiply > OK

 

[Vicki_g]

I'm back. I added the first percentage (2.7%) to the cells and it worked. Now
I need to take the new numbers and add 3%. The formula doesn't seem to be
working now. Is there a conflict between the first percentage I added and now
the new percentage. I'm trying to figure out salary increases for a range of
different pay grades. Thanks.

 

[Gord Dibben]

Did you perform your addition by following G'sS's operation?

If so, just do it again only this time enter 1.03 in an empty cell then paste
special>multiply.


Gord Dibben MS Excel MVP

 

[Vicki_g]

Thanks for the replay. I did retry the instructions using 1.03. It worked the
first time when I did the 1.027, but now, for example, one of my numbers is
22.22. I need to add 3%, which should make it 22.88. Instead, it's making it
493.92. It's probably something simple I'm missing - I don't know the first
thing about Excel!

 

[Gord Dibben]

I have 22.22 in A1.

I enter 1.03 in B1.

Copy B1, select A1 and Paste Special>Multiply>OK>Esc I get 22.8866

The only way I can get 493.92 is to multiply 22.22 * 1.03 * 22.22

So.........yes....you are doing something wrong.

When you figure it out you will no longer be a complete novice at Excel.


Gord Dibben MS Excel MVP

 

[Vicki_g]

This became a personal challenge, but I have figured out my mistake. I was
copying the 1.03 and then COPYING all the other cells instead of just
SELECTING them. I have now learned the error of my ways and am no longer a
complete novice. Thank you!

 

[Gord Dibben]

Good on you for your persistence in trouble-shooting.

You can try the book-learning route but the "do it 'til you get right" route is
most lasting.


Gord