I have 2 boolean columns and I want to compute a 3rd boolean column based on the values in the first two. I realized I can’t do that using IF-THEN-ELSE as there is no AND condition to merge 2 columns ( if am using it right ).
A and B are my existing and I want to set the value of C based on the previous 2 values.
I have set the visibility of B based on my value of A. But my catch here is that a user can set B as TRUE and then A as TRUE where the value of B gets saved (as TRUE) which I don’t want.
What I want
A B C
0 0 0
0 1 1
1 0 0
1 1 0
What is the approach that I should take?
Thanks in advance.