# Need Help with Excel and Flagging Outcomes!

D

#### 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

P

#### 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

D

#### Don Guillett

Have a look in the help index for CHOOSE

T

#### 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))

F

#### 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