Hello!
I want to know how can I use IF statement (in maybe a for or while loop) to change the value of the cell based on a condition of a counter.
"=If(Counter=1,M2,if(Counter=2,M3,if(Counter=3,M4,...."
if my counter = #, the cell value is replaced by a value of M(#+1) as shown in the example above.
the counter is from 1 to 999.
How can I do this?
Bookmarks