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


"John Moore" wrote in message
...
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?

"Pete_UK" wrote:

Try this:

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

Hope this helps.

Pete

On Jul 11, 3:40 pm, John Moore
wrote:
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