Need to add 5% to many rows
 

Hi,
I need to add 5% to the current value of each cell and put the result
in the same cell. Is there an easy way of doing this?
Thanks,
Richard


--
rgloverd
------------------------------------------------------------------------
rgloverd's Profile: http://www.excelforum.com/member.php...o&userid=27249
View this thread: http://www.excelforum.com/showthread...hreadid=467561

STEPS:

In any unused cell, enter 1.05
Go to this unused cell and copy (Ctrl-C)
Highlight the range that you want to increase by 5%
Go to Edit/Paste Special/Multiply

Hope this will help you.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=467561

Thank you very much works perfectly and will save me hours of work :-)


--
rgloverd
------------------------------------------------------------------------
rgloverd's Profile: http://www.excelforum.com/member.php...o&userid=27249
View this thread: http://www.excelforum.com/showthread...hreadid=467561

You are welcome ... thanks for the feedback.

Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=467561