I am making a spreadsheet of what's withheld from employee's paychecks (every
2 weeks) (e.g., health insurance premiums, Flex Spending, etc).


A B C
1 John (F)
2 Mary (S)


Column B lists what kind of coverage the employee has--"F" is Family, "S" is
Single, "C" is Couple--each coverage has a different premium (price).

I need a function for column C that will look at cell B1 and see that "F"
means John subscribes to Family Coverage, and return (to column C) a
particular value; look at cell B2 and see that "S" means Mary subscribes to
Single coverage, and return a different value.

Is there a function/formula that I can utilize to reach this goal? Please,
if you're answering, explain in Lehman's terms. Thanks in advance!