How to record percentage increases in materials costing sheet.

I am trying to do a materials costing sheet where I would like to be able to
periodically increast the base cost of the product by different percentages.
E.g. Cost of Apples $10.00 but might be increased by 5% then 2.5% and
therefore the base cost would keep changing. I know how do first % increase
but not how to then use that figure as the base figure for future
adjustments. Thanks for amy help. I am very new to this.

You could put a % in one cell. Select the cell and give it a name by
Insert-->Name-->Define. Call it "increase".
Then, in the cell where you put the first increase, just change the formula
from =A1*1.05 to =A1*1.05*increase
Or something like that.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"onesonya" <[email protected]> wrote in message
news:[email protected]...
> I am trying to do a materials costing sheet where I would like to be able
to
> periodically increast the base cost of the product by different
percentages.
> E.g. Cost of Apples $10.00 but might be increased by 5% then 2.5% and
> therefore the base cost would keep changing. I know how do first %
increase
> but not how to then use that figure as the base figure for future
> adjustments. Thanks for amy help. I am very new to this.

THANKS FOR YOUR HELP BUT WHAT I NEED IS SOMETHING THAT WILL ALLOW ME TO
CHANGE THE BASE RATE A1 AND MAKE THAT THE NEW AMOUNT TO THEN ADD OTHER
PERCENTAGES.

EG

APPLE COST $1.00
10% RISE NOW COST $1.10 (NEW BASE FIGURE)
5% RISE NOW COST $1.15 (BECOMES BASE FIGURE)
7.5% $1.24.

I APPRECIATE THE TIME YOU TOOK TO ANSWER MY QUESTION.

SONYA

"Anne Troy" wrote:

> You could put a % in one cell. Select the cell and give it a name by
> Insert-->Name-->Define. Call it "increase".
> Then, in the cell where you put the first increase, just change the formula
> from =A1*1.05 to =A1*1.05*increase
> Or something like that.
> *******************
> ~Anne Troy
>
> www.OfficeArticles.com
> www.MyExpertsOnline.com
>