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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Liz Parkes - 21 Nov 2007 12:59 GMT

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

Reply to this Message

Gary''s Student - 21 Nov 2007 14:06 GMT

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?

Signature

Gary''s Student - gsnu200758

> 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

Reply to this Message

Liz Parkes - 21 Nov 2007 15:30 GMT

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

> 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
[quoted text clipped - 6 lines]
> >
> > Liz

Reply to this Message

Gary''s Student - 21 Nov 2007 17:08 GMT

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.

Signature

Gary''s Student - gsnu200758

> I would like to trigger the decrease if the ref. cell grows by 10% over its
> baseline value in a series of updates.
[quoted text clipped - 9 lines]
> > >
> > > Liz

Reply to this Message

Liz Parkes - 22 Nov 2007 12:46 GMT

Thanks for answering my question.
Yours,

Liz

> A1 will contain the original reference value
> B1 will contain the current reference value
[quoted text clipped - 30 lines]
> > > >
> > > > Liz

Reply to this Message

Gary''s Student - 22 Nov 2007 13:03 GMT

You are very welcome.

Signature

Gary''s Student - gsnu200758

> Thanks for answering my question.
> Yours,
[quoted text clipped - 35 lines]
> > > > >
> > > > > Liz

Reply to this Message