Add percentage to a cell
 

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.

Add percentage to a cell
 

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.

Add percentage to a cell
 

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.

Add percentage to a cell
 

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.

Add percentage to a cell
 

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.

Add percentage to a cell
 

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.

Add percentage to a cell
 

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.

Add percentage to a cell
 

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

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.

Add percentage to a cell
 

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

On Wed, 14 May 2008 12:42:00 -0700, Vicki_g
wrote:

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

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.