OR function

[Chris Marigold]

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

 

[Alan]

=IF(OR(A2="Chris",A3="Chris"),"Correct","Incorrect")

 

[Harlan Grove]

=IF(OR(A2="Chris",A3="Chris"),"Correct","Incorrect")

...

A bit more compact to use

=IF(COUNTIF(A2:A3,"Chris"),"Correct","Incorrect")

 

[Alan]

Nice One Harlan!

...
..

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.