If you have many possibilities, you may want to go with a VLOOKUP.

Create a table with your value list in, say, Sheet2, column A and your work
result in column B.

in your desired result cell, type =VLOOKUP(A2,Sheet2!A:B,2,0) to return the
B value.

"Steve" wrote:

I have office student 2003 excell. My problem is getting a single cell to be
examined for content and based what is in there will do one of many things.
ie cell 1 has "A" value and does "z work", if cell 1 has "B" value and does
"y work", if cell 1 has "C" value and does "x work" etc. "IF" statement will
only allow me to do a true or false with an excution. "OR" state will only
allow me to check the cell but not perform something else.
--
Steve