F
fusla
I'd like to create a formula that would apply to a whole column and yield the
same result as...
=C(x-1)-Ax+Bx where x is whatever row number the cell is on.
ex: a1=2 b1=3 c1=1
a2=1 b2=5 c2=c1-a2+b2=1-1+5=5
a3=2 b2=6 c3=c2-a3+b3=5-2+6=9...and so on.
Short of writing out this formula with the actual cell numbers for 100 rows,
is there a way to do this? I've looked around but have been unable to find a
way. Any help would be appreciated. Thanks.
same result as...
=C(x-1)-Ax+Bx where x is whatever row number the cell is on.
ex: a1=2 b1=3 c1=1
a2=1 b2=5 c2=c1-a2+b2=1-1+5=5
a3=2 b2=6 c3=c2-a3+b3=5-2+6=9...and so on.
Short of writing out this formula with the actual cell numbers for 100 rows,
is there a way to do this? I've looked around but have been unable to find a
way. Any help would be appreciated. Thanks.