Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for budget
Good day
this is the excel worksheet before me item Budget Curr Budget Jan Feb Mar comp h/w 5000 **** 1000 500 200 hort 6000 **** animal prod 2000 **** What formula should I use to workout the current budget. So initially I have R5000 then I purchase comp h/w for R1000 in jan the current budget should be R4000 and then purchase comp h/w in feb the current budget should be 3500 and then purchase in mar the curr budget must be 3300. How can u accomplish this? Thanking you |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula statement that would spread an annual budget over 12months | New Users to Excel | |||
Formula for Budget | Excel Discussion (Misc queries) | |||
Excel formula to calculate % difference when actual 1, budget -48 | Excel Discussion (Misc queries) | |||
Formula to return under-budget store locations | Excel Worksheet Functions | |||
Divide Monthly Sales Budget to Day Budget | Excel Worksheet Functions |