Excel 2010 IF function

Can you guys please help me; I need to calculate the insurance PREMIUM base upon the following information.
HMO employee pay $100 per period for 10 or more years of service
HMO employee with less than 10 years of service pay $125.
PPO employee pay $50.00 per period for 10 or more years of service
PPO employee with less than 10 years of service pay $133.


Name      BirthDate      Sex      Health Plan      Years of Service      Insurance Premium
Rod        5/15/1968        F         HMO                      15      
Susi        4/16/1957        F        PPO                     25      
Jake        12/17/1978     F         PPO                       3      
Saul        3/18/1972      M        HMO                     1      
TOTAL                                   $           -  


perla1962Asked:
Who is Participating?
 
dlmilleCommented:
Assuming the options are only HMO or PPO, then you can use this if statment:

=IF(D9="HMO",IF(E9>=10,100,125),IF(E9>=10,50,133))

See attached.

Cheers,

Dave
insurance.xlsx
0
 
perla1962Author Commented:
No wonder I found out my error and you got it for me thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.