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