Thread: OR function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.worksheetfunctions
Alan Alan is offline
external usenet poster
  
Posts: 492
Default 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 With QuoteReply With Quote