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

# 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
1 Solution

Commented:
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

Author Commented:
Thank you very much.
0

## Featured Post

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