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
--
Gary''s Student - gsnu200784


"Vicki_g" wrote:

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.

Thank you so much!!!!!!

"Gary''s Student" wrote:

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
--
Gary''s Student - gsnu200784


"Vicki_g" wrote:

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.

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.

"Gary''s Student" wrote:

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
--
Gary''s Student - gsnu200784


"Vicki_g" wrote:

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.

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


Gord Dibben MS Excel MVP

On Tue, 13 May 2008 16:08:03 -0700, Vicki_g
wrote:

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.

"Gary''s Student" wrote:

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
--
Gary''s Student - gsnu200784


"Vicki_g" wrote:

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.

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" wrote:

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


Gord Dibben MS Excel MVP

On Tue, 13 May 2008 16:08:03 -0700, Vicki_g
wrote:

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.

"Gary''s Student" wrote:

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
--
Gary''s Student - gsnu200784


"Vicki_g" wrote:

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.

I have 22.22 in A1.

I enter 1.03 in B1.

Copy B1, select A1 and Paste SpecialMultiplyOKEsc 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

On Wed, 14 May 2008 11:13:02 -0700, Vicki_g
wrote:

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" wrote:

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


Gord Dibben MS Excel MVP

On Tue, 13 May 2008 16:08:03 -0700, Vicki_g
wrote:

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.

"Gary''s Student" wrote:

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
--
Gary''s Student - gsnu200784


"Vicki_g" wrote:

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.