| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number in cell increase with increase in font size. | Excel Discussion (Misc queries) | |||
| HOW DO COPY A CELL BUT INCREASE ITS REFERENCE BY TWO CELL POSITIO. | Excel Discussion (Misc queries) | |||
| increase cell value | Excel Discussion (Misc queries) | |||
| how to get % increase between 1 cell and another in excel | Excel Discussion (Misc queries) | |||
| how to increase the number by 1 from the cell above? | Excel Worksheet Functions | |||
Linear Mode
