IF(AND condition

[Sasikiran]

Dear,

I need a formula which i am explaining in the below example.

A1 B1 C1 Desired result in column A
= Other xyz.com No
= Meeting (e-mail address removed) No
Other (e-mail address removed) No
Meeting abc.abc.com Yes
Meeting (e-mail address removed) No
Audio 123.dfg.com Yes
Other fsdfs.wed.com No
Record (e-mail address removed) No

I need to validate the columns B & C, and get a text Yes or No in column A
based on the corresponding values in columns B & C using an IF condition.

If column C does not contain @ and If column B is not Other - Then text as
Yes, else No

I am trying with =IF(AND( condition by unable to get the result.

Please help.

 

[Sasikiran]

thank you so much

Hi,

Try this in A1 and drag down

=IF(AND(B1<>"other",ISERROR(FIND("@",C1))),"Yes","No")
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.