Excel 2007 : How to apply Multiple Calculations depending on Text from Drop Down List

[paradise710]

I have created a business expense report. What I am trying to do is calculate the state and federal tax depending on what state the expense was purchased in. I created a drop-down list of states in one cell. At the end of the table, gives you the break down of state (one cell) and federal tax (another cell). The problem is, each state tax is different. So I need the cell, both state and federal, to calculate based on what state is selected from the drop-down list.

-> Total fake tax for ND is 12%, 5% State, 7% Federal.
-> Total fake tax for SD is 15%, 6% State, 9% Federal.
-> Total fake tax for WY is 10%, 3% State, 7% Federal.

I attached an example.

Please help!