multiple if condition

[muddan madhu]

Multiple if condition
Here the two conditions
1) If(a1="ABC","Yes"," ") - if it is true I need "yes" in C1

2) If(b1="XYZ"," ","Yes") - if its false I need "yes" in C1

I need 2 conditions result in C1, how to do that...

Thanks in advance

 

[Ragdyer]

Does this work for you:

=IF(AND(A1="ABC",B1<>"XYZ"),"YES","")
?

 

[Teethless mama]

=IF(OR(A1="ABC",B1<>"XYZ"),"Yes","")

 

[pierre]

try this :

=IF(OR(A1="abc",B1="xyz"),"yes","")

 

[pierre]

sorry instead of b1="xyz" put : b1=<>"xyz"

THAT SHOULD DO IT........

 

[muddan madhu]

I tried all the formula.......... it works if there is value in the
cell .... but it didn't work if there is no value in the cell.

 

[Mike Rogers]

muddan madhu

You need to define "didn't work"!!! If you get an error your can trap for
errors with: IF(ISERROR(Your formula),"",(Your Formula))

Mike Rogers