Have a look in the help index for CHOOSE

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Danny Boy" wrote in message
...
Im using Excel 2007, and here is my question€¦

I want to put a formula in cell C3 that looks at outcomes in cell B3. If
the
raw score outcome in cell B3 has the following values, I would like cell
C3
to provide the following words:

IF: THEN:

B3=Blank C3=Blank
B3= Greater than 0-1.9 C3=Definitely False
B3=2.0-2.9 C3=Mostly False
B3=3.0-3.9 C3=Dont Know
B3=4.0-4.9 C3=Mostly True
B3= 5.0 or greater C3=Definitely True

Thank you for your help!