If AND Query

[Guest]

Hi guys,

How do I return a Y or N answer based on the following. Formula in cell C1
to return either B or C depending on the content of cells A1 and B1 ,,, so if
A1 and B1 = N then return B ,,, if not then return C.
A B C
1 N N B
2 N Y C
3 N N B

 

[Guest]

=IF(AND(A1="N",B1="N"),"B","C")

 

[Pete_UK]

Try this:

=IF(AND(A1="N",B1="N"),"B","C")

Hope this helps.

Pete

 

[PCLIVE]

Not sure about the "How do I return a Y or N answer" since it seems you want
"B" or "C". But it seems you want this:

=IF(AND(A1="N",B1="N"),"B","C")

Another way:
=IF(COUNTIF(A1:B1,"N")=2,"B","C")

HTH,
Paul

 

[Guest]

This works in that when both A1 and B1 = N the formula returns B ,,, but when
they don't both contiain N it still returns B .....when it should return C
...... any thoughts?

 

[PCLIVE]

That shouldn't be the case. Try hitting F9 to recalculate.