annual budget - by month help needed

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.
 
S

Sheeloo

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.
 
D

David

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
 
D

David Biddulph

=IF(OR(January!B3 = 0,January!B3 =""),0, January!B3-January!E3)
but I don't understand what you are trying to say in the later part of your
question.
 
D

David

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top