• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 283
  • Last Modified:

Excel 2010 IF function

Can you please help me out I’m trying to calculate the insurance PREMIUM Base upon the following information HMO Employees pay $100.00 per period and PPO employees pay $50.00 per period.

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                                   $           -  

0
perla1962
Asked:
perla1962
1 Solution
 
chakkoCommented:
here is a basic formula.  Start with Health plan first row as D2  and premium as F2

in F2 put    

=IF(D2="HMO",50,100)

Then use the autofill to copy F2 down the column  (drag it from bottom right corner, down the column)

If D2 is HMO then it sets 100 in F2, otherwise it puts 100

0
 
perla1962Author Commented:
Thank you very much.
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now