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