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
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