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

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

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.

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.