this is a 2 part questionI have a list of 11 items in a drop down menu in
column A that when selected I need to have a corresponding value appear in
column B, C and D. I think I can only do 7 nestings and would like to do all
11, plus have the ability to register a 0 for anything not in the formula.

For example:
Column A B C D E
Auto Single 10 1 0
Auto Multi 15 1 0
Life 0 0 1 $163

The 2nd part is to take the annual life insurance premiums from column E and
have it generate an point total equaling 5 points per $100 rounded down and 2
points per $100 for an anuuity premium rounded down.

Thank you in advance for your help!