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 this may be possible, but it would be helpful to see a sample of your data with the expected results. You can post screen images using the tools mentioned in this thread here: http://www.mrexcel.com/forum/showthread.php?t=508133

 

[UglyBunny]

Hi Keswick,

I don't know what a 'speck' is, and I don't know if you want it to say 'fail speck a' and 'pass speck b' if someone got a 2.1, for example, but I hope this will help you =)

=IF(IF(AND(A1<=2,A1>=1),1,0)=1,"Pass Speck A",IF(AND(A1<=2.1,A1>=0.9),"Pass Speck B","Fail"))

Just change all 4 "A1"s to whatever cell the test result's in.

 

[kezwick]

speck is just short for specification me being lazy and would that work for multiple cells? so if i have 8 cells i need it to change if only 1 goes out ill try and explain it better
in a table of 10 results i would like it to change if even 1 goes out but i have 2 different specifiations one less strict so it can fail the tight specification but pass the wider one hence fail a pass b its hard to explane as i cant send nething else due to the work it contains and the work PC's are so strict im supprised its letting me do even this lol

 

[kezwick]

that works but only for single cells if i want it for multiple cells how can i do that tried just going A1,A2,A3 ect but i need it if any of them go out chears for this u guys are like excel gurus

 

[kezwick]

i think i got a way to explain it better ahha im trying to say if any of the cells C14 to C18 are not between 1.0 and 2.0 in cell B2 say fail if they are say Pass
i duno y i didnt say that in the first place lol

 

[Joe4]

i think i got a way to explain it better ahha im trying to say if any of the cells C14 to C18 are not between 1.0 and 2.0 in cell B2 say fail if they are say Pass
i duno y i didnt say that in the first place lol

Will there always be values in C14:C18, or might there be blanks?

 

[kezwick]

yea there will be blanks the cells i need are C17 C18 and c27 i tryied using "C17,C18,C27" but it needed all those cells to equal the querys.

 

[Joe4]

i think i got a way to explain it better ahha im trying to say if any of the cells C14 to C18 are not between 1.0 and 2.0 in cell B2 say fail if they are say Pass
i duno y i didnt say that in the first place lol

yea there will be blanks the cells i need are C17 C18 and c27 i tryied using "C17,C18,C27" but it needed all those cells to equal the querys.

OK, this feels like a moving target, as it appears you keep changing the details of the question. In order to get a good answer that works for you, you are going to need to be clear, concise, and accurate.

I think a visual representation might go a long way here, if you could post a sample with your expected results, like I asked in post #2.

 

[kezwick]

i replyed to that post, i cant post nethng due to company regulations the target has been the same just finding better ways to simplify it to make it easyer to understand. i just need a formula that says essentialy if C17 or C18 or C27 then say fail in B2