I'm doing a lotto chart for work.  The initial investment is $250.  If we
win or lose, I would like to key in the amount in the respective column and
have the amount column automatically update itself.  The one thing I can't
figure out is how to take the previous days amount and make it part of the
formula.  Any help is greatly appreciated.  Thanks.  I don't know if the
example chart I've put in will translate well on the upload but this is how
the chart looks.  Thanks once again.

      Initial Investment Win Lose Amount
     250   10 240
       10   250
       153   353
         30 323