NESTING THE IF COMMAND WITH THE OR COMMAND

[KEN]

I WANT TO CHECK CELL A1 FOR THE VALUE OF "X"
I WANT TO CHECK CELL B1 FOR THE VALUE OF "X"
I WANT TO CHECK CELL C1 FOR THE VALUE OF "X"
I WANT TO CHECK CELL D1 FOR THE VALUE OF "X"
IF ONE OR MORE OF THESE CELLS ARE EQUAL TO "X" THEN I
WANT TO PUT "YES" IN CELL E1, IF THERE IS NO "X" IN ANY
OF THE CELLS CHECKED THEN PUT "NO" IN CELL E1


THANK YOU IN ADVANCE FOR THE HELP

KEN

 

[Louise]

Try this:

=IF(OR(A1="X",B1="X",C1="X",D1="X"),"YES","NO")


Regards,
Louise