Expert: Aidan Heritage - 11/4/2009

Question
I am trying to make a tax projection worksheet for individuals.  I would like to be able to change the tax formula located in one cell, based on the contents of the filing status cell.  

I have four different formulas to compute tax based on four different filing statuses.  Ideally, I would like a drop down box in one cell to choose filing status.  When that status is selected I would like the formula in that tax cell to change (correspond) to the selected status.

Any insights?

Answer
Drop down box would be data, validation.  The calculation method could be as simple as a set of IF statements

=if(FilingStatus=1,firstcalc,if(filingstatus=2,secondcalc,if(filingstatus=3,thirdcalc,fourthcalc)))

would be the basic principle.  It is possible that this could be simplified depending on what the calculations are - and obviously you would need to replace my dummy references and values with actual references, values and calculations.

Hope this helps but let me know if I can help further - should you need it my email is aidan.heritage@virgin.net