| 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 |
| 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) | |||
Threaded Mode
