Add percentage to a cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vicki_g - 08 May 2008 01:36 GMT

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.

Reply to this Message

Gary''s Student - 08 May 2008 01:44 GMT

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

Signature

Gary''s Student - gsnu200784

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

Reply to this Message

Vicki_g - 08 May 2008 16:40 GMT

Thank you so much!!!!!!

> 1. enter 1.027 in an un-used cell
> 2. copy this cell
[quoted text clipped - 4 lines]
> > cells. How can I add 2.7% to a range of existing cells (b72-g85). I have
> > Excel 2003. Thank you.

Reply to this Message

Vicki_g - 14 May 2008 00:08 GMT

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.

> 1. enter 1.027 in an un-used cell
> 2. copy this cell
[quoted text clipped - 4 lines]
> > cells. How can I add 2.7% to a range of existing cells (b72-g85). I have
> > Excel 2003. Thank you.

Reply to this Message

Gord Dibben - 14 May 2008 04:08 GMT

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

>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
[quoted text clipped - 10 lines]
>> > cells. How can I add 2.7% to a range of existing cells (b72-g85). I have
>> > Excel 2003. Thank you.

Reply to this Message

Vicki_g - 14 May 2008 19:13 GMT

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!

> Did you perform your addition by following G'sS's operation?
>
[quoted text clipped - 17 lines]
> >> > cells. How can I add 2.7% to a range of existing cells (b72-g85). I have
> >> > Excel 2003. Thank you.

Reply to this Message

Gord Dibben - 14 May 2008 19:51 GMT

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

>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
[quoted text clipped - 23 lines]
>> >> > cells. How can I add 2.7% to a range of existing cells (b72-g85). I have
>> >> > Excel 2003. Thank you.

Reply to this Message

Vicki_g - 14 May 2008 20:42 GMT

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!

> I have 22.22 in A1.
>
[quoted text clipped - 37 lines]
> >> >> > cells. How can I add 2.7% to a range of existing cells (b72-g85). I have
> >> >> > Excel 2003. Thank you.

Reply to this Message

Gord Dibben - 14 May 2008 21:37 GMT

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

>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
[quoted text clipped - 42 lines]
>> >> >> > cells. How can I add 2.7% to a range of existing cells (b72-g85). I have
>> >> >> > Excel 2003. Thank you.

Reply to this Message

Rate this thread: