another formula IF issue

[kezwick]

hi guys/gals
this i think is a big one i have a table that i fill in for test results, i would like a IF formula to say if any of the cells equal over speck 'a' then say "Fail speck 'a', Fail speck 'b'" and if not "Pass speck 'a', Pass speck 'b'" for example the 2 specks are a outer and inner speck so A=1.0 to 2.0 and B=0.9 to 2.1. so it could be fail a pass b so theres 3 outcomes can any1 help or is this even possible?
thanks again all

 

[Joe4]

I think a variation of the formula uglybunny provided to you should work:

=IF(AND(AND(C17>=1,C17<=2),AND(C18>=1,C18<=2),AND(C27>=1,C27<=2)),"Pass","Fail")