Home |
Search |
Today's Posts |
#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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |