Add percentage to a cell

  • Thread starter Thread starter Vicki_g
  • Start date Start date
V

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.
 
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
 
Thank you so much!!!!!!

Gary''s Student said:
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
Click to expand...
 
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.
 
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
 
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!
 
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
 
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!
 
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
 
Back
Top