help with a IF formula
=IF(COUNTBLANK(A4:AF4)=32,"",IF(OR(K4=2,L4=2,P4=2, Q4=2,T4=2,U4=2,X4=2),
"FAIL","PASS"))
--
John C
"Nadine" wrote:
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
"John C" wrote:
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.
--
John C
"Nadine" wrote:
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
|