| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Not just True/False
I'm would like to have a cell display Pass, Conditional, or Fail depending on
a score in another cell. For example, if the score is below 60, display Fail, between 60 and 70 display Provisional, 70, display Pass. I can get pass/fail, but not the three responses. Help??? Thanks -- Dan Davenport |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Not just True/False
=IF (A1 < 60, "Fail", IF (60<=A1<=70,"Conditional","Pass"))
"DWD" wrote: I'm would like to have a cell display Pass, Conditional, or Fail depending on a score in another cell. For example, if the score is below 60, display Fail, between 60 and 70 display Provisional, 70, display Pass. I can get pass/fail, but not the three responses. Help??? Thanks -- Dan Davenport |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Not just True/False
Got it, Bob... Thanks...D
-- Dan Davenport "BobT" wrote: =IF (A1 < 60, "Fail", IF (60<=A1<=70,"Conditional","Pass")) "DWD" wrote: I'm would like to have a cell display Pass, Conditional, or Fail depending on a score in another cell. For example, if the score is below 60, display Fail, between 60 and 70 display Provisional, 70, display Pass. I can get pass/fail, but not the three responses. Help??? Thanks -- Dan Davenport |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Not just True/False
Try this:
=IF(A1<60,"Fail",IF(A1<=70,"Provisional","Pass")) HTH, Elkar "DWD" wrote: I'm would like to have a cell display Pass, Conditional, or Fail depending on a score in another cell. For example, if the score is below 60, display Fail, between 60 and 70 display Provisional, 70, display Pass. I can get pass/fail, but not the three responses. Help??? Thanks -- Dan Davenport |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Not just True/False
Got it.... Thanks...D
-- Dan Davenport "Elkar" wrote: Try this: =IF(A1<60,"Fail",IF(A1<=70,"Provisional","Pass")) HTH, Elkar "DWD" wrote: I'm would like to have a cell display Pass, Conditional, or Fail depending on a score in another cell. For example, if the score is below 60, display Fail, between 60 and 70 display Provisional, 70, display Pass. I can get pass/fail, but not the three responses. Help??? Thanks -- Dan Davenport |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Not just True/False
=IF(B2<60,"Fail",IF(AND(B260,B2<71),"Provisional" ,"pass"))
Change B2 to the cell your looking at. "DWD" wrote: I'm would like to have a cell display Pass, Conditional, or Fail depending on a score in another cell. For example, if the score is below 60, display Fail, between 60 and 70 display Provisional, 70, display Pass. I can get pass/fail, but not the three responses. Help??? Thanks -- Dan Davenport |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Not just True/False
Got it... Thanks much to all... D
-- Dan Davenport "Newbeetle" wrote: =IF(B2<60,"Fail",IF(AND(B260,B2<71),"Provisional" ,"pass")) Change B2 to the cell your looking at. "DWD" wrote: I'm would like to have a cell display Pass, Conditional, or Fail depending on a score in another cell. For example, if the score is below 60, display Fail, between 60 and 70 display Provisional, 70, display Pass. I can get pass/fail, but not the three responses. Help??? Thanks -- Dan Davenport |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check box - true/false - i'd like a third option n/a | Excel Discussion (Misc queries) | |||
| Return True/False to check duplicate items in a range with one for | Excel Worksheet Functions | |||
| Boolean 0/1 instead of True/False | Excel Discussion (Misc queries) | |||
| Look up to return a true/false value | Excel Worksheet Functions | |||
| Want to change the color of a true/false logical statement with i. | Excel Worksheet Functions | |||
Hybrid Mode
