Thread: OR function
View Single Post
  #2   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
=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




Reply With QuoteReply With Quote