Thread
:
combine IF, AND and OR operstors in a statement
View Single Post
#
10
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
combine IF, AND and OR operstors in a statement
Take the rest of the day off.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Vince" wrote in message
...
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett