cell content change so...

C

CC

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
 
J

Jacob Skaria

Apply the formula in cell D2 and copy/drag down upto D10

=$C$1-(($C$1-$C$2)*ROW()*10%)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Check if cell content changed 4
Help with formula in vb coding 5
Pasting a cell into bookmarked table from excel vba 1
Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26
How to read from txt file from bottom to top? 3
How to maintain size of array: UniqRow 4
For Next Loop and If..."Relative dose*"...Then 9
[VBA] Get the content of each value of a line 8

Top