Need Help with Excel and Flagging Outcomes!

[Danny Boy]

I’m 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=Don’t Know
B3=4.0-4.9 C3=Mostly True
B3= 5.0 or greater C3=Definitely True

Thank you for your help!

 

[Per Jessen]

Hi

This should do it:

=IF(B3=0,"",IF(B3<2,"Definetely False",IF(B3<3,"Mostly False",IF(B3<4,"Don't
Know",IF(B3<5,"Mostly True","Definetely True")))))

Regards,
Per

 

[Don Guillett]

Have a look in the help index for CHOOSE

 

[T. Valko]

Create a 2 column table like this...

...........J.......K....................
1.......0.......Definitely False
2.......2.......Mostly False
3.......3.......Don't Know
4.......4.......Mostly True
5.......5.......Definitely True

Then use this formula in C3:

=IF(B3="","",VLOOKUP(B3,J1:K5,2))

 

[Francis]

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),"Don’t
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