Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF formula statement that would spread an annual budget over 12months
I'd like to create an IF type formula that will take an annual budget
keyed into say cell A1 and spread it over 12 months based on options numbers say 1-10 For example, selecting option number 1 would allocate the annual budget evenly over 12 months, option number 2 would allocated the annual budget over four quarters, option number 3 would allocate the budget over the first two months and last two months of the year and so one. Each option number would be based on a percentage weighting laid out on another worksheet within that same workbook. Is something like this possible? Any help is greatly appreciated. Robert |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
IF formula statement that would spread an annual budget over 12 mo
A cell formula can only act on the cell that contains it.
You could write (possibly nested) IF formulas in each cell, but your post provided too little information about the sheet layout for specifics. As a starting point, a monthly cell might contain something like =IF(optioncell=1,A1/12,"") Instead of writing formulas in each cell, another approach would write a VBA macro that would populate the relevant cells, but that is a more advanced topic than is likely wanted in a newusers' post. Jerry " wrote: I'd like to create an IF type formula that will take an annual budget keyed into say cell A1 and spread it over 12 months based on options numbers say 1-10 For example, selecting option number 1 would allocate the annual budget evenly over 12 months, option number 2 would allocated the annual budget over four quarters, option number 3 would allocate the budget over the first two months and last two months of the year and so one. Each option number would be based on a percentage weighting laid out on another worksheet within that same workbook. Is something like this possible? Any help is greatly appreciated. Robert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Budget Spread methods | Excel Worksheet Functions | |||
How can the last 12months on the x-axis auto update each month? | Charts and Charting in Excel | |||
delete entirerow if date more than 12months old | Excel Discussion (Misc queries) | |||
Formulas calculate specified percentage of annual budget in Excel | Excel Worksheet Functions | |||
How do you calc half day annual leave on a xls spread sheet using. | Excel Worksheet Functions |