NESTING THE IF COMMAND WITH THE OR COMMAND

  • Thread starter Thread starter KEN
  • Start date Start date
K

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
 
Back
Top