Excel Formula - if values in columns all contain X then return

0
votes

I have an excel formula where 3 columns (A,B, C) check values and if true, return "OK", I have a fourth column (D) where I want to check if all 3 columns contain "OK" then return text. I have tried various formulas and changing OK to blank and using ISBLANK formula but still not working. Can anyone please advise?

The formula in A,B C is =IF(A2 = "Cell Site Change - Implementers","OK","Missing Site Change IMP")

thank you.

2
excelif-statementformula

2 Answers

0
votes
=IF(COUNTIF(A1:A3,"OK")=3,"Yes","No")

Where A=A1, B=A2, C=A3

And the value for the 3 cells is with the formula:

=IF(A1="Cell Site Change - Implementers", "OK", "NOT OK")

You can extend it for multiple cells by using so you don't have to compute the number of cells you compare:

=IF(COUNTIF(A1:A5,"OK") = COUNTIF(A1:A5,"*"),"Yes","No")
0
votes

You can use the AND function:

= IF(AND(A3="OK";B3="OK";C3="OK");"everything is great";"something is missing")

where A, B and C are in A3, B3 and C3 respectively.