Help With a Formula

  • Thread starter Thread starter Bill Davis Jr
  • Start date Start date
B

Bill Davis Jr

Need help with a formula if it is possible.

Let's say I am working on a budget. In Column A I have a list of
balances, example A1-A12. I Column B I have a cell with a set amount
of dollars.

Is there a formula that when I payoff one of the balances with the
amount in the cell in Column B I know how much I have left to pay off
another balance? I hope I explained that right.

Thanks,

Bill
 
Ok, your balances are in A1:A12
Your "stash" is in B1
in C1 put =B1-A1 that will be how much of your stash is left after you pay
balance A1 off
In C2 put =C1-A2 and copy it on down to C12 and each row in column C will
reflect the amount of stash left after paying the balance in column A of
that row...........hopefully, there will be something left in C12..........

Vaya con Dios,
Chuck, CABGx3
 
Back
Top