combine IF, AND and OR operstors in a statement
It's kind of confusing to know what you mean when you said ""creates an
error" given that if the logical test is not met, you return the word
"ERROR". Anyway, I tried your code and it does what it says... if I16 has
either a "Y" or "?" in it AND if I24 has a "?", then "Please enter country
code" is display; if either of those cells contain anything else, the word
"ERROR" is returned... the code does work and no worksheet errors are
generated. What is it you thought should happen that prompted you to post
your question?
Rick
"Vince" wrote in message
...
How do I nest AND & OR operators in an IF statement? E.g. the statement
=IF(AND(OR(I16="Y",I16="?"),I24="?"),"Please enter country code","ERROR")
creates an error
|