If either field doesnt contain a value then enter text

[creative999]

Hi

I need help with a formula to enter into C1.

If A1 AND B1 = NO, then C1 = NO.
If A1 OR B1 contains a value, then C1 = value from A1 or B1.

Thank you in advance.

 

[Joe4]

What is A1 and B1 BOTH contain values?
Then what should cell C1 show?

And what exactly is in cells A1 and B1?
Are they numeric entries, date entries, or text entries?

 

[6StringJazzer]

What do you mean by "a value"? Do you mean any value?

Here I am assuming that "has a value" means "not blank."

=IF(AND(A1="NO",B1="NO"),"NO",IF(A1<>"",A1,IF(B1<>"",B1,"")))

If A1 and B1 both have values, then it uses the A1 value.
If A1 and B1 are both blank, then the result is blank (you did not specify that case)

 

[creative999]

What is A1 and B1 BOTH contain values?
Then what should cell C1 show?

And what exactly is in cells A1 and B1?
Are they numeric entries, date entries, or text entries?

The values (text) in A1 or B1 could be the same (other than "NO")

 

[creative999]

What do you mean by "a value"? Do you mean any value?

Here I am assuming that "has a value" means "not blank."

=IF(AND(A1="NO",B1="NO"),"NO",IF(A1<>"",A1,IF(B1<>"",B1,"")))

If A1 and B1 both have values, then it uses the A1 value.
If A1 and B1 are both blank, then the result is blank (you did not specify that case)

A1 or B1 will never be blank. They will contain some text or be NO

 

[Joe4]

The values (text) in A1 or B1 could be the same (other than "NO")

That really doesn't answer my question.

Is it possible that BOTH A1 and B1 could both have values?
If so, is it possible that they could have DIFFERENT values?
If cell A1 and B1 both have values, and they are different, what exactly do you want returned in cell C1?
Do you want the combined values, or a certain one?

For example, what if A1 has "Cat" and B1 has "Dog".
What then exactly do you want to see in cell C1 in that case?

 

[creative999]

That really doesn't answer my question.

Is it possible that BOTH A1 and B1 could both have values?
If so, is it possible that they could have DIFFERENT values?
If cell A1 and B1 both have values, and they are different, what exactly do you want returned in cell C1?
Do you want the combined values, or a certain one?

For example, what if A1 has "Cat" and B1 has "Dog".
What then exactly do you want to see in cell C1 in that case?

Assumption is that a1 and b1 won’t have different values. However, for the rare exception that they do, c1 should combine the values.
Hope that helps.

 

[Joe4]

OK, I think this formula should cover ALL your possibilities:

=IF(AND(A1="NO",B1="NO"),"NO",IF(AND(A1<>"",B1<>"",A1<>B1),A1&B1,IF(A1<>"",A1,IF(B1<>"",B1,""))))