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


"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