This sounds like it should be easy to do in a spreadsheet, but... If cell A is < cell B then Subtract 100 from cell C and put it into Cell A Joel P.S. I am planning retirement. I want to see how long my money will hold out, and am looking at shifting money around between categories of investments over a particular time frame.