software

I have a financial worksheet where there are certain rows of numbers
that need to be increased or decreased by a %.

How can I increase the number in each cell in a row by a set
percentage? An entire row will go up by the same percentage.

I thought this would be an easy one - but apparently have gone brain
dead from the weekend.....Thanks for your help!--
jshgolf
------------------------------------------------------------------------
jshgolf's Profile: www.excelforum.com/member.php...oamp;userid=24840
View this thread: www.excelforum.com/showthread...hreadid=521771Hi

Into an empty unused cell type your factor (eg 1.1 for 10% rise, 1.5 for 50%
etc). Copy this with Ctrl C, select your row and then Edit/Paste
Special/Multiply.
Make a backup before you start!

Hope this helps.
Andy.

quot;jshgolfquot; gt; wrote in
message ...
gt;
gt; I have a financial worksheet where there are certain rows of numbers
gt; that need to be increased or decreased by a %.
gt;
gt; How can I increase the number in each cell in a row by a set
gt; percentage? An entire row will go up by the same percentage.
gt;
gt; I thought this would be an easy one - but apparently have gone brain
gt; dead from the weekend.....Thanks for your help!
gt;
gt;
gt; --
gt; jshgolf
gt; ------------------------------------------------------------------------
gt; jshgolf's Profile:
gt; www.excelforum.com/member.php...oamp;userid=24840
gt; View this thread: www.excelforum.com/showthread...hreadid=521771
gt;
On Mon, 13 Mar 2006 10:31:16 -0600, jshgolf
gt; wrote:

gt;
gt;I have a financial worksheet where there are certain rows of numbers
gt;that need to be increased or decreased by a %.
gt;
gt;How can I increase the number in each cell in a row by a set
gt;percentage? An entire row will go up by the same percentage.
gt;
gt;I thought this would be an easy one - but apparently have gone brain
gt;dead from the weekend.....Thanks for your help!

Perhaps I'm missing something, but how about in A2
=A1*1.05
if you want to uplift A1 by 5%, and copy across columns as necessary
Then Copy the whole of row 2 and Paste Special Values back on Row 1

Better still, put 1.05 in a named cell , called say 'Uplift' and then
have
=A1*Uplift
Which means you only have to change one cell next time you need to
increase your cells.

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________