Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Data via Web Query - Can values be passed to query? | Excel Discussion (Misc queries) | |||
Save data retreived from query without saving query | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) |