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.
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...