Thanks for answering my question.
Yours,

Liz

"Gary''s Student" wrote:

A1 will contain the original reference value
B1 will contain the current reference value
C1 will contain the orgininal value of the quantity to be depreciated
D1 will contain:

=(1-INT(10*(B1-A1)/A1)*0.0218)*C1

For example:

100 106 1234 1234

the current value is only up by 6%, so no depreciation

100 111 1234 1207.0988

the current value is more than 10% higher, so one step depreciation

100 124 1234 1180.1976

Now two steps, etc.
--
Gary''s Student - gsnu200758


"Liz Parkes" wrote:

I would like to trigger the decrease if the ref. cell grows by 10% over its
baseline value in a series of updates.

"Gary''s Student" wrote:

Do you want to trigger the decrease if the reference cell increases by 10% in
one update, or trigger the decrease if the reference cell grows by 10% over
its baseline value in a series of updates?
--
Gary''s Student - gsnu200758


"Liz Parkes" wrote:



In Excel 2003, I would like to find out how to make the value in one cell
decrease by 2.18% each time the value in another cell increases by 10%.

Thanks.

Liz