raising multiple cells containing numbers by a percentage
 

How do you raise multiple cells containing numbers at one time by a percentage.

raising multiple cells containing numbers by a percentage
 

Let's say you want 7%
In some empty cell (say Z1) type 1.07 and copy this value
Select the range the be changed and use Edit | Paste Special with Multiply
checked off in the dialog; click OK
Now you can delete Z1

Back up you file before you start this in case you err.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Tammy Dean" wrote in message
...
How do you raise multiple cells containing numbers at one time by a
percentage.

raising multiple cells containing numbers by a percentage
 

Thank you so much.

"Bernard Liengme" wrote:

Let's say you want 7%
In some empty cell (say Z1) type 1.07 and copy this value
Select the range the be changed and use Edit | Paste Special with Multiply
checked off in the dialog; click OK
Now you can delete Z1

Back up you file before you start this in case you err.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Tammy Dean" wrote in message
...
How do you raise multiple cells containing numbers at one time by a
percentage.

raising multiple cells containing numbers by a percentage
 

Enter your number in a blank cell e.g. for 50% enter 1.5 as the multiplying
factor
With this cell highlighted click Copy
Highlight all the cells you wish to raise by this percentage.
Select Edit - Paste Special - Radio button Multiply - Click OK
All the cells highlighted will be multiplied by 1.5 i.e. raised by 50%

"Tammy Dean" wrote:

How do you raise multiple cells containing numbers at one time by a percentage.