Excel 2010 IF function

Posted on 2011-10-28
Last Modified: 2012-05-12
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                                   $           -  

Question by:perla1962
    LVL 22

    Accepted Solution

    here is a basic formula.  Start with Health plan first row as D2  and premium as F2

    in F2 put    


    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


    Author Closing Comment

    Thank you very much.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
    Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now