multiply a row of numbers by %
 

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: http://www.excelforum.com/member.php...o&userid=24840
View this thread: http://www.excelforum.com/showthread...hreadid=521771

multiply a row of numbers by %
 

Hi

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.

"jshgolf" wrote in
message ...

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:
http://www.excelforum.com/member.php...o&userid=24840
View this thread: http://www.excelforum.com/showthread...hreadid=521771

multiply a row of numbers by %
 

On Mon, 13 Mar 2006 10:31:16 -0600, jshgolf
wrote:


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!

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
__________________________