If AND Query
 

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

If AND Query
 

=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

If AND Query
 

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

If AND Query
 

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


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

If AND Query
 

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

If AND Query
 

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