annual budget - by month help needed

  • Thread starter Thread starter David
  • Start date Start date
D

David

I have a workbook with 13 sheets in it,
January(A4) - Beginning Balance(B4), Amount Due(C4), Amount Paid(E4)
|
|
\/
December
and a totals sheet
in the description col.(A) are monthly bills and revolving card bills. so
the bills that are monthly will not have a begining balance - on those i
would like the Begining Balance(B4) to = Ammount due(C4)

I need february begining balance to be janurary's amount paid - begining
balance

i think i need something like this;

if January!B4 = 0 or EMPTY then February!C4=February!B4
else
February!B4= February!B4 - February!E4

Thanks in advance, any and all help is appreciated.
 
You have give the complete solution (if you are willing to enter the formula
in all the sheets)
Enter this in February!B4
=IF(January!B4 = 0,B4, B4-E4)

Similarly for each month..

Or you can try to build a formula, using INDIRECT, so that the previous
month is picked... Don't know whether it would be worth the effort.
 
Thanks that is part of the solution, here is what I have working;

=IF(January!B3 = 0,0, January!B3-January!E3)

I also need to check for a empty(blank)cell - something like;

=IF(January!B3 = 0 or January!B3 =BLANK,0, January!B3-January!E3)

and lastly, if a amount is entered in January!C3 and January!B3 = 0 then the
amount entered in - January!C3 needs to be the same in January!B3 like;

January!B3 = January!C3

how can I combine these into one formula?

Thanks
 
lets see if I can explain, for the 12 month sheets feb looks at jan
(begining balance), mar looks at feb(begining balance) and so on, when I
test this formula in feb all works great if there is a value in beginning
balance and amount due col. - for credit cards, this is what I asked for.
for non credit cards I have no beginning balance just an amount due so the
formula works if I enter the same amount in both the beginning balance and
amount due col.

I am trying to get a formula that will work whether it is a monthly bill or
a credit card. I can zip up the workbook and let you have a look if that
would help, I would not have any formulas or anything in the wb to be on the
safe side, just the worksheets.

Thanks, David D.
 
Back
Top