I am developing a spreadsheet for us to use at for keeping track of bonuses.
I have 7 columns - date, policyholder, policy, type, premium, bonus, and
initials. The date, policyholder and premium columns we'll fill in. I have
created dropdown boxes for the policy and type columns. I want the bonus
column to fill itself based on either what is chosen in the type column or to
calculate 2% of the premium, (depending on which it used), but I can't seem
to make any function work.

I tried the following formula for the type, but it didn't work.

=IF(D5=CD/ASSISTED,CHECKING,CREDIT CARD,DECLINED/WORKED LOAN,MONEY
MARKET,MUTUAL FUND ASSISTED,SAVINGS, "10.00", IF(D5=ANNUITY IRA/TSA
ASSIST/REFERRAL,ASSURANT STUDENT,HOSPITAL INCOME,LOAN W/OUT CREIDT
DISABILITY,MEDICARE SUPPLEMENT,MORTGAGE DISABILITY INCOME,TERM,
"25.00",IF(D5= ANNUITY IRA/TSA,ASSURANT INDIVIDUAL MEDICAL,LOAN W/CREDIT
DISABILITY,LONG TERM CARE,MORTGAGE LOAN CLOSED,UNIVERSAL LIFE,WHOLE LIFE,
"50.00")))

HELP!!