Need Help with Excel and Flagging Outcomes!
 

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!

Need Help with Excel and Flagging Outcomes!
 

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

"Danny Boy" skrev i meddelelsen
...
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!

Need Help with Excel and Flagging Outcomes!
 

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!

Need Help with Excel and Flagging Outcomes!
 

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

--
Biff
Microsoft Excel MVP


"Danny Boy" wrote in message
...
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!

Need Help with Excel and Flagging Outcomes!
 

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!