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

Question

In an excel formula, columns A, B, and C check values and, if true, return "OK." Column D is where I want to see whether all three columns contain "OK," in which case I want to return text. I've tried other formulas, including converting OK to blank and utilising the ISBLANK formula, but they haven't been successful. Is anyone willing to offer advice?

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

Answer 1

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.