Fail / Pass question

[Besh]

Hi there,

If cell F23 displays < 70%, I want it to display "Fail" in G23
If cell F23 displays = or > than 70%, I want it to display "Pass" in G23
If cell F23 displays blank, I want it to display "Not Evaluated"

I'm using Excel 2007. How would I go about accomplishing this?

 

[VoG]

Try

=IF(F23="","Not Evaluated",IF(F23<0.7,"Fail","Pass"))

 

[T. Valko]

Hi there,

If cell F23 displays < 70%, I want it to display "Fail" in G23
If cell F23 displays = or > than 70%, I want it to display "Pass" in G23
If cell F23 displays blank, I want it to display "Not Evaluated"

I'm using Excel 2007. How would I go about accomplishing this?

Try this...

=IF(F23="","Not Evaluated",IF(COUNT(F23),IF(F23<70%,"Fail","Pass"),""))

 

[Besh]

Works, thanks to both of you.

 

[mikerickson]

How about
=CHOOSE(1+(A1>0.7)+(A1<>""), "Not Evaluated", "fail", "Pass")

 

[T. Valko]

Works, thanks to both of you.

You're welcome. Thanks for the feedback!

 

[Besh]

Great, they all seem to work, but I now have another question:

Is there a way to make a #DIV/0! in F23 "not evaluted" in G23 as well?

I ask b/c I have the percentage equation is in F23, when there are no numbers to the left of it, a error code is displayed in F23, which is fine, but when expressing the pass or fail I rather a "not evaluated" than that.

<TABLE style="WIDTH: 239pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=318><COLGROUP><COL style="WIDTH: 34pt; mso-width-source: userset; mso-width-alt: 1645" width=45><COL style="WIDTH: 55pt; mso-width-source: userset; mso-width-alt: 2669" width=73><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 3035" width=83><COL style="WIDTH: 88pt; mso-width-source: userset; mso-width-alt: 4278" width=117><TBODY><TR style="HEIGHT: 24.75pt" height=33><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #a5a5a5; WIDTH: 34pt; HEIGHT: 24.75pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 height=33 width=45>Passes</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #a5a5a5; WIDTH: 55pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=73>Out of</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #a5a5a5; WIDTH: 62pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=83>%</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #a5a5a5; WIDTH: 88pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl66 width=117>Pass/Fail</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=20 align=right>25</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>26</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 align=right>96.15%</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65>Pass</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=20 align=right>0</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=right>0</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 align=middle>#DIV/0!</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 align=middle>#DIV/0!</TD></TR></TBODY></TABLE>

 

[VoG]

Try

=IF(ISERROR(F23),"Not evaluated",IF(F23="","Not Evaluated",IF(F23<0.7,"Fail","Pass")))

 

[Besh]

wow, works. thanks again. i'm new here, let me know if there's anything i'm supposed to do as a asker once i've been helped.

 

[T. Valko]

let me know if there's anything i'm supposed to do as a asker once i've been helped.

You're supposed to send me a check for $18,000,000.00 USD!