If...and... - can never get the syntax correct!
Spell checker got me Julie, no offence :-)
Regards
Bod
"Bob Phillips" wrote in message
...
Hi Judie,
"JulieD" wrote in message
...
the "not sure" condition can be met under the following circumstances
AND(A2="No", A3="")
AND(A2="No",A3="Yes ")
AND(A2=" ",A3="No")
as I said, as stated by the OP ...
In A2, either a yes or no
In A3 either a yes or no
anyway the OP can decide which formula to use :)
Well, he has few choices :-)
|