Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
raising multiple cells containing numbers by a percentage
How do you raise multiple cells containing numbers at one time by a percentage.
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing multiple cells by the same percentage | New Users to Excel | |||
Increase numbers by 15% in multiple cells | Excel Discussion (Misc queries) | |||
Sum multiple cells with different numbers and text. | Excel Discussion (Misc queries) | |||
UDF Raising an error | Excel Worksheet Functions | |||
How do I delete multiple cells with decimal, not whole, numbers? | Excel Worksheet Functions |