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