Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Flagging Up Stock On Excel 2000 | Excel Discussion (Misc queries) | |||
Flagging with Excel | Excel Discussion (Misc queries) | |||
Flagging data in Excel | Excel Discussion (Misc queries) | |||
Spell check flagging words I can't find in Excel | Excel Discussion (Misc queries) | |||
256 possible outcomes | Excel Discussion (Misc queries) |