Increase several ranges of numbers by a fixed percentage

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

Hello:

I've got a bunch of Excel-XP price sheets in which I need
to increase all of my cost numbers by 3%. These numbers
appear in vertical ranges (not named and not contiguous).

I can write a formula to do one cell, but I need a faster
way to increase a whole range, or better yet several
ranges, by a single percentage.

Excel help screens didn't help.

Thanks for your help.
 
Hi Dave,

In an mt cell enter 1.03. Now copy this cell and select
the range where your cost numbers are. Then select
Edit>paste Special>Multiply

Biff
 
Sorry - that should have been 1.03.

Jason
-----Original Message-----
1. Key .03 into an open cell.
2. Copy that cell.
3. Hold down the <Ctrl> key and select all target cells
with your mouse.
4. Edit > Paste Special > Multiply

HTH
Jason
Atlanta, GA


.
Click to expand...
 
Biff:

Thanks for your help.

Dave
-----Original Message-----
Hi Dave,

In an mt cell enter 1.03. Now copy this cell and select
the range where your cost numbers are. Then select
Edit>paste Special>Multiply

Biff

.
Click to expand...
 
Jason:

Thanks for your 2 replies.

Dave
-----Original Message-----
1. Key .03 into an open cell.
2. Copy that cell.
3. Hold down the <Ctrl> key and select all target cells
with your mouse.
4. Edit > Paste Special > Multiply

HTH
Jason
Atlanta, GA


.
Click to expand...
 
Back
Top