multiply a row of numbers by %

[jshgolf]

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!

 

[Guest]

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.

 

[Richard Buttrey]

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
__________________________