Have 3 cells that I need to know if all are over 95%

[stacyg]

I have been playing with If(and( statements trying to get it to work but I guess I just am not sure how to get it to work in this scenario.

I have a percentage result in M2, N2 and O2. I am trying to see if all three values are individually over 95% and if so, I want to enter "Review", if not "".

 

[Jonmo1]

Try

=IF(MIN(M2:O2)>95%,"Review","")

 

[Smitty]

Maybe:

=IF(AND(M2>0.95,N2>0.95,O2>0.95),"Review","")

HTH,

 

[stacyg]

Smitty, your response worked perfect thanks. I was so close to your solution but I threw in an extra if(and( that wsa not needed. The only issue with your solution was I needed to change < to > for my use.

Bryans solution I had already basically tried. That one uses a sum function and it did not do what I needed but thanks for the quick reply. It gave me review results when only 2 were below .95.

Thanks guys, really appreciate it.

Stacy

 

[Jonmo1]

Bryans solution I had already basically tried. That one uses a sum function and it did not do what I needed but thanks for the quick reply. It gave me review results when only 2 were below .95.

Who is Bryan?

If you're referring to my formula
=IF(MIN(M2:O2)>95%,"Review","")

It is NOT using SUM... I don't know where you got that from..

It produces the same result as the IF(AND structure

Excel 2010

	M	N	O	P	Q	R
MIN	IF(AND
Review	Review

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]100%[/TD]
[TD="align: right"]100%[/TD]
[TD="align: right"]100%[/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]100%[/TD]
[TD="align: right"]100%[/TD]
[TD="align: right"]80%[/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]100%[/TD]
[TD="align: right"]70%[/TD]
[TD="align: right"]80%[/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]60%[/TD]
[TD="align: right"]70%[/TD]
[TD="align: right"]80%[/TD]
[TD="align: right"][/TD]

</tbody>

Sheet2​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]Q2[/TH]
[TD="align: left"]=IF(MIN(M2:O2)>95%,"Review","")[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]R2[/TH]
[TD="align: left"]=IF(AND(M2>0.95,N2>0.95,O2>0.95),"Review","")[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]Q3[/TH]
[TD="align: left"]=IF(MIN(M3:O3)>95%,"Review","")[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]R3[/TH]
[TD="align: left"]=IF(AND(M3>0.95,N3>0.95,O3>0.95),"Review","")[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]Q4[/TH]
[TD="align: left"]=IF(MIN(M4:O4)>95%,"Review","")[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]R4[/TH]
[TD="align: left"]=IF(AND(M4>0.95,N4>0.95,O4>0.95),"Review","")[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]Q5[/TH]
[TD="align: left"]=IF(MIN(M5:O5)>95%,"Review","")[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]R5[/TH]
[TD="align: left"]=IF(AND(M5>0.95,N5>0.95,O5>0.95),"Review","")[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[stacyg]

Sorry, I saw Bryan Texas. I am not wearing a contact so I am sort of blind. I am sorry I meant to say stating a range a2:a4 not sum. However, your solution did not work the same I promise you. I tried it and I got completely different results between the two. Below is that results I got. The first 3 are the results from the other formula and the last 3 from yours. Again thanks for your help, I didn't want to sound at all unappreciative.
[TABLE="width: 518"]
<colgroup><col span="3"><col><col></colgroup><tbody>[TR]
[TD="align: right"]1-Oct[/TD]
[TD="align: right"]1-Nov[/TD]
[TD="align: right"]1-Dec[/TD]
[TD]Formula[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]94%[/TD]
[TD="align: right"]98%[/TD]
[TD="align: right"]94%[/TD]
[TD] [/TD]
[TD]{=IF(AND(A2<0.95,B2<0.95,C2<0.95),"Review","")}[/TD]
[/TR]
[TR]
[TD="align: right"]100%[/TD]
[TD="align: right"]100%[/TD]
[TD="align: right"]100%[/TD]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]94%[/TD]
[TD="align: right"]94%[/TD]
[TD="align: right"]94%[/TD]
[TD]Review[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]94%[/TD]
[TD="align: right"]98%[/TD]
[TD="align: right"]94%[/TD]
[TD]Review[/TD]
[TD]{=IF(MIN(M2:O2)>95%,"Review","")}[/TD]
[/TR]
[TR]
[TD="align: right"]100%[/TD]
[TD="align: right"]100%[/TD]
[TD="align: right"]100%[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]94%[/TD]
[TD="align: right"]94%[/TD]
[TD="align: right"]94%[/TD]
[TD]Review[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Jonmo1]

{=IF(AND(A2<0.95,B2<0.95,C2<0.95),"Review","")}

That is NOT the same formula Smitty Posted.

Maybe:

=IF(AND(M2>0.95,N2>0.95,O2>0.95),"Review","")

HTH,

You changed > to <, that's a HUGE difference and does not match up with the description you posted.

I am trying to see if all three values are individually over 95% and if so, I want to enter "Review", if not "".

Explains why my formula 'didn't work'.

Try
=IF(MAX(M2:O2)<95%,"Review","")

 

[stacyg]

[h=2]Have 3 cells that I need to know if all are over 95%[/h]I said I had 3 cells that I need to know if all 3 are over 95% but really meant under, sorry for the confusion.
>>If all cells are under 95% then "Review" otherwise, if over then blank.
You are completely correct and hence why I changed the formula. It does work and does what I needed, thanks for helping me understand this better.
Stacy

 

[Jonmo1]

You're welcome