The formula says if cell G4 on sheet 2 is empty say "Bad" otherwise say "Good". You could try this formula in cell E10 on Sheet 1.....#=IF(AND('Sheet 2'!G4="X",'Sheet 2'!H4=""),"Good",IF(AND('Sheet 2'!H4="X",'Sheet 2'!G4=""),"Bad",IF(AND('Sheet 2'!G4="X",'Sheet 2'!H4="X"),"Error","")))#.

This formula whilst a little clumsy does allow for you accidentally inputting "X" in both columns G & H. If you do this, it shows "Error".