Assume your data is in cell A, and
tabulated in B.
just use formula for cell B:
=if(cell(A) <-400,-400,cell(A))
if you want the original cell balance to carry down,
=if(cell(A)<-400,cell(B(n-1)),cell(A))
Unless I"m missing something, this is a trivial problem and does not require...