How can I increase value in one cell as value in other decreases?

[Guest]

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

 

[Guest]

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?

 

[Guest]

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

 

[Guest]

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.

 

[Guest]

Thanks for answering my question.
Yours,

Liz

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.

 

[Guest]

You are very welcome.