View Single Post
  #2   Report Post  
BenjieLop
 
Posts: n/a
Default


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