IF function

IF function

Didn't find your answer?

Hi all,

Just a quick question about the IF function. Is there a way to make an IF formula so that you can check for two names at once. Example: =if(a1="name1" or "name2",true,false) tells me I have an error with the function. It's ok if I only use "name1" and no OR function but without using an if function within the if function is there a way of searching two names?

Apologies if this makes no sense whatsoever. Thanks in advance :)

Replies (3)

Please login or register to join the discussion.

avatar
By User deleted
03rd Nov 2014 12:16

Try google search ...

criteria '.. excel if statement containing or ..'

=IF(OR(A1<-10.05,A1>22.55),FALSE,TRUE)

http://www.excelforum.com/excel-formulas-and-functions/482927-if-stateme...

 

Thanks (1)
avatar
By paulwakefield1
03rd Nov 2014 12:17

Just a bit of reordering

=if(OR(a1="name1",a1="name2"),true,false)

Thanks (1)
avatar
By Paul Hawes
03rd Nov 2014 12:55

Thanks

Brain fart, it was so simple all along. Thanks very much for that!

Thanks (0)