I don't think this is possible. But, I figured i could be wrong (yet again.)
Desired outputs for Param C based on different conditions:
A=Yes and B=1 should produce C= "Good Choice"
A=No and B=1 should produce C= ""
A=Yes and B=2 should produce C="Do Not Use"
A=No and B=2 should produce C=""
I can almost get this to work by adding another parameter.
D= if(B=1,"Good Choice","")
C= if(and(A, B=1),D,"Do Not Use"
I just can't get the last state.
The problem is, an if() statement can only have 2 values. So, when B=1, the if() can read D but when B=2 Param C always reports "Do Not Use" regardless of the State of A.
Ideas?
Desired outputs for Param C based on different conditions:
A=Yes and B=1 should produce C= "Good Choice"
A=No and B=1 should produce C= ""
A=Yes and B=2 should produce C="Do Not Use"
A=No and B=2 should produce C=""
I can almost get this to work by adding another parameter.
D= if(B=1,"Good Choice","")
C= if(and(A, B=1),D,"Do Not Use"
I just can't get the last state.
The problem is, an if() statement can only have 2 values. So, when B=1, the if() can read D but when B=2 Param C always reports "Do Not Use" regardless of the State of A.
Ideas?
Comment