Cashflow and dropdown list cell for quarterly, annual, s-curve, monthly block not working

[cglinka]

Hi,
Im writing a cashflow for work and i want to automate the line item input for cashflow of a $ amout. I have had success writing the formulas for each option individually when i combine the formulas for use with a dropdown menu input cell by using defined names, some of the options stop working.
Spreadsheet is uploaded here.
Once working, this should be a pretty neat time saving tool for cashflowing of multiple objects
Any help would be greatly appreciated.
130707_Cashflow Question Upload.xlsx

[JBeaucaire]

Which cell? What part of the formula in that cell is not doing what you expect?

If it's N12, then perhaps your 3 individual formulas can be entered into this formula with less trouble. Each formula based on what is selected in D12 will slip into a specific slot in this formula.


=CHOOSE(MATCH($D12, {"Annual","Quarterly","Once Off Block"}, 0), PutFormulaForAnnualHere, PutFormulaForQuarterlyHere, PutFormulaForOnceOffHere)