If then help needed

[melmartin]

Can someone tell me what if then statement I would use in order to calculate the following:

If W2=Y2 (or) if X2 = Y2, then return "yes - okay", if W2 doesn't equal Y2 or if X2 doesn't equal Y2, then return "no - review".

Thanks so much for the help!

 

[njimack]

=IF(COUNTIF(W2:X2,Y2),"yes - ok","no - review")

 

[Asala42]

Standard IF(OR()) syntax would look like this:

=IF(OR(X2=Y2,W2=Y2),"yes - ok","no - review")

 

[mohammad2060]

You can use this formula:
=if(or(w2=y2;x2=y2);"yes_okey";if(or(w2<>y2;x2<>y2);"no_riview"))

 

[melmartin]

This worked! Thanks so much for your help!!!!