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
1					MIN	IF(AND
2	100%	100%	100%		Review	Review
3	100%	100%	80%
4	100%	70%	80%
5	60%	70%	80%

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet2​

Worksheet Formulas Cell Formula Q2 =IF(MIN(M2:O2)>95%,"Review","") R2 =IF(AND(M2>0.95,N2>0.95,O2>0.95),"Review","") Q3 =IF(MIN(M3:O3)>95%,"Review","") R3 =IF(AND(M3>0.95,N3>0.95,O3>0.95),"Review","") Q4 =IF(MIN(M4:O4)>95%,"Review","") R4 =IF(AND(M4>0.95,N4>0.95,O4>0.95),"Review","") Q5 =IF(MIN(M5:O5)>95%,"Review","") R5 =IF(AND(M5>0.95,N5>0.95,O5>0.95),"Review","") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[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.

1-Oct	1-Nov	1-Dec	Formula
94%	98%	94%		{=IF(AND(A2<0.95,B2<0.95,C2<0.95),"Review","")}
100%	100%	100%
94%	94%	94%	Review
94%	98%	94%	Review	{=IF(MIN(M2:O2)>95%,"Review","")}
100%	100%	100%
94%	94%	94%	Review

<colgroup><col span="3"><col><col></colgroup><tbody>
</tbody>

 

[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