Please help me with the following. This is in Excel 2003.
The actual business process revolves around loan funding and setting loan
advance amounts. Below A1 is borrowing limit, A2 is loan advance, A3 is loan
balance, A4 is advance availability
cell A1 = varying amount
cell A2 = A4 - 1
cell A3 = A2 + varying amount
cell A4 = A1-A3 + varying amount
This is circular, but I believe that I need that. We want the advance A2 to
be as large as possible and A4 to be 1 each day. And I would like these
figures to update when the varing amounts change. Thanks.