Solved

# Excel 2010 IF function

Posted on 2011-10-28
203 Views
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
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

=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 Closing Comment

Thank you very much.
0

## Featured Post

### Suggested Solutions

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…