I am having problem posting to this forum as it shows Service unavailable

Anyway, try this

=IF(B3="","",IF(AND(B3=0,B3<=1.9),"Definitely
False",IF(AND(B3=2,B3<=2.9),"Mostly False",IF(AND(B3=3,B3<=3.9),"Dont
Know",IF(AND(B3=4,B3<=4.9),"Mostly True","Definitely True")))))

This doesn't take into account for negative number as in your requirement
--
Hope this help

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis





"Danny Boy" wrote:

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!