multiple if condition

  • Thread starter Thread starter muddan madhu
  • Start date Start date
M

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
 
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.
 
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
 
Back
Top