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
|