IF Statement
Good one.
There's always someone who thinks outside the box. LOL
"Teethless mama" wrote:
Try this:
=AND(D3="pn",OR(E3={"m","n"}))+0
"bob" wrote:
If D3 contains the string "pn" and if E3 contains either "m" or "a", I want
the value in I3 to be 1.
If D3 does not contain "pn" and E3 does not contain "M" or "A", I want I3 to
be zero.
Can someone provide a formula to do this?
Thanks very much,
Bob
|