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

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

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

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

How can I increase value in one cell as value in other decreas
 

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

How can I increase value in one cell as value in other decreas
 

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

How can I increase value in one cell as value in other decreas
 

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

How can I increase value in one cell as value in other decreas
 

You are very welcome.
--
Gary''s Student - gsnu200758


"Liz Parkes" wrote:

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