C chaitanya New Member Jul 12, 2019 #1 Hi, Please help me if a columns A1 to G1 consists F char then it should display Fail else Pass
AliGW Well-Known Member Jul 12, 2019 #2 Not a great thread title, is it? Doesn't tell us much about your issue. Just imagine if every thread started with "Help!"!!! =IF(COUNTIF(A1:G1,"F")=COLUMNS(A1:G1),"Fail","Pass") Or maybe you want this: =IF(COUNTIF(A1:G1,"F")>0,"Fail","Pass")
Not a great thread title, is it? Doesn't tell us much about your issue. Just imagine if every thread started with "Help!"!!! =IF(COUNTIF(A1:G1,"F")=COLUMNS(A1:G1),"Fail","Pass") Or maybe you want this: =IF(COUNTIF(A1:G1,"F")>0,"Fail","Pass")
GraH - Guido Well-Known Member Jul 12, 2019 #3 AliGW said: Not a great thread title, is it? Click to expand... But a great old song, right?
B bosco_yip Excel Ninja Jul 12, 2019 #4 Or, this one in a bit shorter : =COUNTIF(A1:G1,"F") and, Custom cell format, enter : [=]"Pass";"Fail" Regards Bosco Last edited: Jul 13, 2019
Or, this one in a bit shorter : =COUNTIF(A1:G1,"F") and, Custom cell format, enter : [=]"Pass";"Fail" Regards Bosco
