| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.worksheetfunctions
|
|||
|
|||
OR function
Hello all,
Sorry for such a numpty question, but for the life of me I can't figure it out. I want to do the following: IF (A2 or A3="Chris","Correct","incorrect") I know it should look something like =IF(OR(A2,A3)="Chris", "correct","incorrect")) , but this doesn't seem to work. Can you help? Chris |
|
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.worksheetfunctions
|
|||
|
|||
|
OR function
=IF(OR(A2="Chris",A3="Chris"),"Correct","Incorrect ")
"Chris Marigold" wrote in message ... Hello all, Sorry for such a numpty question, but for the life of me I can't figure it out. I want to do the following: IF (A2 or A3="Chris","Correct","incorrect") I know it should look something like =IF(OR(A2,A3)="Chris", "correct","incorrect")) , but this doesn't seem to work. Can you help? Chris |
|
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.worksheetfunctions
|
|||
|
|||
|
OR function
"Alan" wrote...
=IF(OR(A2="Chris",A3="Chris"),"Correct","Incorrec t") ... A bit more compact to use =IF(COUNTIF(A2:A3,"Chris"),"Correct","Incorrect") -- Never attach files. Snip unnecessary quoted text. Never multipost (though crossposting is usually OK). Don't change subject lines because it corrupts Google newsgroup archives. |
|
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.worksheetfunctions
|
|||
|
|||
|
OR function
Nice One Harlan!
"Harlan Grove" wrote in message ... "Alan" wrote... =IF(OR(A2="Chris",A3="Chris"),"Correct","Incorrec t") .. A bit more compact to use =IF(COUNTIF(A2:A3,"Chris"),"Correct","Incorrect") -- Never attach files. Snip unnecessary quoted text. Never multipost (though crossposting is usually OK). Don't change subject lines because it corrupts Google newsgroup archives. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming | |||
Linear Mode
