N Nadine Aug 5, 2008 #1 If any cell in a range of cells A4:AF4 contain the number 2, pass or fail if a cell contains a 2 want result to show value of fail
If any cell in a range of cells A4:AF4 contain the number 2, pass or fail if a cell contains a 2 want result to show value of fail
J John C Aug 5, 2008 #2 Assuming you mean, you have a row, A4:AF4 (32 cells). If any of the cells have a 2 in it, then FAIL, otherwise pass? =IF(COUNTIF(A4:AF4,2)>0,"FAIL","PASS") If this isn't what you mean, perhaps rephrase the question.
Assuming you mean, you have a row, A4:AF4 (32 cells). If any of the cells have a 2 in it, then FAIL, otherwise pass? =IF(COUNTIF(A4:AF4,2)>0,"FAIL","PASS") If this isn't what you mean, perhaps rephrase the question.
N Nadine Aug 5, 2008 #4 Yes, Thanks. Now how do I change it, to show nothing until a cell has been filled in. Keep cell that contains forumla empty, until it meets the criteria
Yes, Thanks. Now how do I change it, to show nothing until a cell has been filled in. Keep cell that contains forumla empty, until it meets the criteria
N Nadine Aug 5, 2008 #5 No they have changed the criteria. If specific cells containt a 2 K4,L4,P4,Q4,T4,U4,X4
D desertres Aug 5, 2008 #6 For than one way to skin this cat...but I would use the countif formula... =IF(COUNTIF(A4:AF4,2)>0,"FAIL","PASS")
For than one way to skin this cat...but I would use the countif formula... =IF(COUNTIF(A4:AF4,2)>0,"FAIL","PASS")
D desertres Aug 5, 2008 #7 IF(OR(K4=2,L4=2,P4=2,Q4=2,T4=2,U4=2,X4=2), "FAIL","PASS") you could also define a range on those columns and make a better formula.....
IF(OR(K4=2,L4=2,P4=2,Q4=2,T4=2,U4=2,X4=2), "FAIL","PASS") you could also define a range on those columns and make a better formula.....
J John C Aug 5, 2008 #9 =IF(COUNTBLANK(A4:AF4)=32,"",IF(OR(K4=2,L4=2,P4=2,Q4=2,T4=2,U4=2,X4=2), "FAIL","PASS"))
N Nadine Aug 5, 2008 #10 Thanks John C. I got this working, had to rework it a bit. =IF(COUNTBLANK(H4:AF4)=25,"",IF(OR(K4=2,L4=2,P4=2,Q4=2,T4=2,U4=2,X4=2),"Yes","No"))
Thanks John C. I got this working, had to rework it a bit. =IF(COUNTBLANK(H4:AF4)=25,"",IF(OR(K4=2,L4=2,P4=2,Q4=2,T4=2,U4=2,X4=2),"Yes","No"))