Thanks - yes it does work - my bloodshot eye focus must have been playing up.
In the office at 7am today and still at the computer at 10.20 ! Sad or what?


"Don Guillett" wrote:

I just tested this and it worked as advertised when i24 contained ? and i16
either y or ?
=IF(AND(OR(I16="Y",I16="?"),I24="?"),"Please enter country code","MM")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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