View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David David is offline
external usenet poster
 
Posts: 6
Default annual budget - by month help needed

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.