Home |
Search |
Today's Posts |
#1
|
|||
|
|||
percentage increase
I want to increase a group of cells in an Excel document by a percentage. How do I do this? Thanks -- bigjeffscv ------------------------------------------------------------------------ bigjeffscv's Profile: http://www.excelforum.com/member.php...o&userid=27571 View this thread: http://www.excelforum.com/showthread...hreadid=470915 |
#2
|
|||
|
|||
bigjeffscv Wrote: I want to increase a group of cells in an Excel document by a percentage. How do I do this? Thanks Let's assume that your group of cells will be in A1:A100. Here is what you need to do: 1. In any unused cell, enter (1+ the percentage) 2. Go to this cell and copy it (Ctrl-C) 3. Highlight the cells, A1:A100 4. Go to "Edit/Paste Special/Multiply" 5. Click OK Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=470915 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Percentage increase in excel | Excel Discussion (Misc queries) | |||
Increase figures in cells by a percentage (on entire workbook) | Excel Worksheet Functions | |||
Percentage Calculation | Excel Worksheet Functions | |||
How to increase an entire collumn by a certain percentage? | Excel Discussion (Misc queries) | |||
Percentage increase | Excel Worksheet Functions |