Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell content change so...
Hi,
i´d like to know if there´s a way to, programatically or via a formula, check a cell value is changed and add a pecenentage of the diference until reach the new value ex- in the columm C line 1 I have 3500 and if in the next line the value is 3000 i need that in the column D line 2 3500 - (3500- 3000 *20%) in line 3 , 4 , 5 etc same until reach the 3000 ( value of new entrance) - Tks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
cell content change so...
Apply the formula in cell D2 and copy/drag down upto D10
=$C$1-(($C$1-$C$2)*ROW()*10%) -- Jacob "CC" wrote: Hi, i´d like to know if there´s a way to, programatically or via a formula, check a cell value is changed and add a pecenentage of the diference until reach the new value ex- in the columm C line 1 I have 3500 and if in the next line the value is 3000 i need that in the column D line 2 3500 - (3500- 3000 *20%) in line 3 , 4 , 5 etc same until reach the 3000 ( value of new entrance) - Tks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing the cell format doesn't change existing cell content | Excel Discussion (Misc queries) | |||
Cell content change Event | Excel Programming | |||
Change Cell Content | Excel Discussion (Misc queries) | |||
change content of a given cell as different cells are indicated | Excel Worksheet Functions | |||
how do I change the content of one cell based on another? | Excel Discussion (Misc queries) |