How do I apply a % increase to range of cells?

[DaveMWare]

Hello:

I've got a bunch of Excel XP worksheets with columns of numbers (prices) to
which I wish to apply a 3% increase. I know how to write a formula for a
single cell, but not one that will go down a range of cells and make the change
cell by cell. It would be also very helpful to be able to change
non-contiguous ranges of cells. BTW, these ranges are not labeled/named.

Can you suggest a formula?

Thanks

 

[Dave]

-----Original Message-----
DaveMWare -
numbers (prices)
to which I wish to apply a 3% increase. I know how to write a formula for a
single cell, but not one that will go down a range of cells and make the
change cell by cell. It would be also very helpful to be able to change
non-contiguous ranges of cells. BTW, these ranges are not labeled/named.
Can you suggest a formula? <

Here's a non-formula method: Enter 1.03 in a cell somewhere; edit | copy.
Select the cells that need the 3% increase; edit | paste special | multiply.

- Mike Middleton, www.usfca.edu/~middleton


.

Mike:
Thanks for your help. It works!
BTW, Middleton is one of my family names. In fact it's my
middle name. I was named after my great uncle who, as a
young engineer, went down on the Titanic. His name was
Alfred. Do you know anything about your family name? Feel
free to email me directly.
Dave