Does this work for you:

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"muddan madhu" wrote in message
...
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