percentage increase
 

I want to increase a group of cells in an Excel document by a
percentage.
How do I do this?
Thanks :confused:


--
bigjeffscv
------------------------------------------------------------------------
bigjeffscv's Profile: http://www.excelforum.com/member.php...o&userid=27571
View this thread: http://www.excelforum.com/showthread...hreadid=470915

bigjeffscv Wrote:
I want to increase a group of cells in an Excel document by a
percentage.
How do I do this?
Thanks :confused:

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