Function that will look at letter in a columnand return a numeric value to adjacent column

L

locasciok1

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel 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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function that will look at letter in a column and return a number 3
writing a value to a particular cell from function 3
Formula to return a value in column B conditional upon the value in Column A 1
Look Up Multiple Values in a Column based on single Criteria 3
Return multiple values in one cell doing a single value lookup 4
Search the column and return a cell value 15
Lookup a name if cell value first letter is in a range 1
VLOOKUP Function to return values in multipal Columns 6

Top