'Message' using a lookup formula

[dmj120]

Is there a way to have a formula do:

if any cell F3:F23 is less than -.25 or more than .1 "explain"?

I have a conditional formula =AND($F11<>-1,OR($F11<-0.25,$F11>0.1)) that works great but I'd really like to have a formula that looks in the entire column, and if any cell is "out of tolerance" then a 'message' is displayed in A1.

Thanks!

 

[Eric W]

Try this in A1:

=IF(COUNTIF(F3:F23,"<-.25")+COUNTIF(F3:F23,">.1"),"At least one value out of tolerance.","")

 

[dmj120]

Awesome! Thanks, works perfectly.

 

[Eric W]

Glad to help!