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
try something like the following in C1
=IF(OR(A1="Yes",B1="Yes"),"No","")
 
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","")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
A data validation question 1
Retrieve Formula Result when Saving 3
Remove specific cells in a column. 2
Time Calculations Help 4
Re. Conditional formating of adjacent cells but down a column 0
Excel VBA 1
Can a formula do this? 1

Back
Top