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!

I can help with the first question, but I don't understand the second one.

For the first question, you should put the 11 items on a separate worksheet,
and in the following columns, put in their respective values. Then you can
use VLOOKUP in your spreadsheet to populate the other columns based on these
values. Check out the Help on VLOOKUP to see how it is done.
--
Daryl S


"myinsuranceguy" wrote:

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!