Leave Cell BLANK if no criteria met

  • Thread starter Thread starter Neon520
  • Start date Start date
N

Neon520

What do I need to do if I want to leave the cell blank if non of the criteria
met?

I've tried this nested IF function in cell A3:

If(AND(A1="YES",A2"OK"),True_Action, Else
if(AND(A1="YES2",A2="OK"),True_Action, Else "")

As you can see that I've tried using "" to leave the cell blank if no
criteria met, but instead the cell show 0

I think this problem might be because there is also another formula in A4
that also depend on the criteria in A1 and A2, as following:

If(AND(A1="NO",A2"OK"),True_Action, Else
if(AND(A1="NO2",A2="OK"),True_Action, Else "")

Because A2 is also always "OK" in both cases, so the formula in A3 is
partially meet the criteria, that's why it show 0 instead of blank cell....

Do I have the right guess?

Please help me out!!
Thanks,
GU
 
Try it like this:

=IF(AND(A1="Yes",A2="OK"),do_this,IF(AND(A1="Yes2",A2="OK"),do_this,""))
 
Back
Top