View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default 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