Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to automatically update a 12 month budget | Excel Discussion (Misc queries) | |||
IF formula statement that would spread an annual budget over 12months | New Users to Excel | |||
annual growing rate formula or funtion needed!! | Excel Worksheet Functions | |||
Formulas calculate specified percentage of annual budget in Excel | Excel Worksheet Functions | |||
How do I set up a Yearly, by month, budget in Excel? | Excel Discussion (Misc queries) |