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

 

[Poh]

Hi
Place the following formula in cell E1:
=IF(COUNTIF(A11,"X")>0,"YES","NO")