Cell Comparison giving a result

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My spreadsheet has a Column 1 and Column 2.
Information entered should be a "Yes" in either Column 1 or 2. I am trying to find a formula that would be something like this.

If cell A1 or cell B1 contains a "Yes" (a "Yes" would only be entered in one of the two cells, not both)
If either cell contains a "Yes" then display a "No" in cell C1. Have been trying to use =IF(TRAVACCOM!J8="Y","N/A"," ") but only works for cell A1. I am new at this and would really appreciate feedback. Perhaps the actual formula would be really great
 
Hi,

You can check for only one yes being entered for the C1 formula:

=IF(OR(AND(A1="Yes",B1<>"Yes"),AND(A1<>"Yes",B1="Yes")),"No","")
 
Back
Top