Suleman:
Thanks for suggestion.
I tried the example formula you suggested.
It worked for an individual cell, but not for a range of cells. When I tried
a range of cells the same total appeared in all the cells.
Is there some way in the formula to specify a range (example C5 thru C200)?

--
ShirleyF


"Suleman Peerzade" wrote:

Hi Shirley,

This might help you.
1. For eg the existing data is in Sheet 3 and you want to increase the prise
by 10% in all the columns as mentioned by you.
2. Give a name to the existing work sheet so that you can track the change
in price.
3. Go to Toolbar/Insert/Worksheet.
4. For eg the existing sheet is renamed as December and the prices will
change in January 08. Then rename the new worksheet as Jan 08. Then copy the
headings and data of the previous sheet in this new sheet and keep the cells
of price columns empty. Enter the below mentioned formula in it.

='Dec 07'!A2*10%+'Dec 07'!A2 . Here the percentage can be changed to any
number for eg 15%.

You can change the cell reference number like A3 or D3 in the formula
depending upon where the data for ListPrice,DealerPrice and DistributorPrice
is entered.

Once you get the require figure in the require cell then simply paste this
formula in column cells and you will get the results increased by the
percentage you had typed.

--
Thanks
Suleman Peerzade


"Shirley" wrote:

New to this. Am using Office-Excel 2000. Have entered three columns of prices
for company (List, Dealer, Distributor). Prices will increase next month.
How do I increase all rows (example C3-C50) by 10 percent?
Will need to do this for all three columns.
--
ShirleyF