Increase by percentages
 

How do I increase numbers in a range of cells by a percentage amount. For
instance I have a price list on a spreadsheet and I want to increase each
price by 8%. How do I do this? I am using Excel 2003.

One way:

Enter 1.08 in a blank cell. Copy the cell. Select your range. Choose
Edit/Paste Special, selecting the Values and Multiply radio buttons.


In article ,
"TRINI" wrote:

How do I increase numbers in a range of cells by a percentage amount. For
instance I have a price list on a spreadsheet and I want to increase each
price by 8%. How do I do this? I am using Excel 2003.

One way:

Select an unused cell and enter 1.08
Right click and choose "Copy"

Select the cells you wish to increase,
Right click in that selection and choose "Paste Special",
Click on "Multiply", then <OK, then <Esc.
And you're done!

However, if your price list is formatted to $ or any other format, you could
format the cell containing the 1.08 *before* copying, so as not to remove
the already existing format in the cells to be incremented.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"TRINI" wrote in message
...
How do I increase numbers in a range of cells by a percentage amount. For
instance I have a price list on a spreadsheet and I want to increase each
price by 8%. How do I do this? I am using Excel 2003.

One way
In a helper cell type 1.08 copy and highlight range Editpaste
specialmultiply
HTH

"TRINI" wrote:

How do I increase numbers in a range of cells by a percentage amount. For
instance I have a price list on a spreadsheet and I want to increase each
price by 8%. How do I do this? I am using Excel 2003.

Hi, thanks for your response. I have tried this but when I clicked on paste
special there was no multiply option, only options are unicode text & text.
Any ideas?

"RagDyeR" wrote:

One way:

Select an unused cell and enter 1.08
Right click and choose "Copy"

Select the cells you wish to increase,
Right click in that selection and choose "Paste Special",
Click on "Multiply", then <OK, then <Esc.
And you're done!

However, if your price list is formatted to $ or any other format, you could
format the cell containing the 1.08 *before* copying, so as not to remove
the already existing format in the cells to be incremented.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"TRINI" wrote in message
...
How do I increase numbers in a range of cells by a percentage amount. For
instance I have a price list on a spreadsheet and I want to increase each
price by 8%. How do I do this? I am using Excel 2003.

Whoops sorry, ignore my last post, must have done something wrong last time,
it has worked fine now, Thanks for your help.

"RagDyeR" wrote:

One way:

Select an unused cell and enter 1.08
Right click and choose "Copy"

Select the cells you wish to increase,
Right click in that selection and choose "Paste Special",
Click on "Multiply", then <OK, then <Esc.
And you're done!

However, if your price list is formatted to $ or any other format, you could
format the cell containing the 1.08 *before* copying, so as not to remove
the already existing format in the cells to be incremented.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"TRINI" wrote in message
...
How do I increase numbers in a range of cells by a percentage amount. For
instance I have a price list on a spreadsheet and I want to increase each
price by 8%. How do I do this? I am using Excel 2003.

Appreciate the feed-back.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"TRINI" wrote in message
...
Whoops sorry, ignore my last post, must have done something wrong last time,
it has worked fine now, Thanks for your help.

"RagDyeR" wrote:

One way:

Select an unused cell and enter 1.08
Right click and choose "Copy"

Select the cells you wish to increase,
Right click in that selection and choose "Paste Special",
Click on "Multiply", then <OK, then <Esc.
And you're done!

However, if your price list is formatted to $ or any other format, you
could
format the cell containing the 1.08 *before* copying, so as not to remove
the already existing format in the cells to be incremented.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"TRINI" wrote in message
...
How do I increase numbers in a range of cells by a percentage amount. For
instance I have a price list on a spreadsheet and I want to increase each
price by 8%. How do I do this? I am using Excel 2003.