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

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

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

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

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

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

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