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

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

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

"muddan madhu" wrote:

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

try this :

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

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

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

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.

On Apr 13, 9:40*pm, pierre wrote:
sorry *instead of * b1="xyz" * * put : *b1=<"xyz"

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

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

"muddan madhu" wrote:

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.

On Apr 13, 9:40 pm, pierre wrote:
sorry instead of b1="xyz" put : b1=<"xyz"

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