View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vince Vince is offline
external usenet poster
 
Posts: 102
Default combine IF, AND and OR operstors in a statement

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