Several AND operators in if() function

Questions & Answers
1

Hi there, sorry for what seems to be a basic programming question, but:

To set a new variable, I’m using an if() function to determine the contents of 4 prior variables: if they’re all false, I want the new variable to be true. If at least one of them is true, I want the new variable to be false.

Here is getting all 4 prior variables:

image
image1362×842 120 KB

Here is setting the new variable:

image
image1252×924 127 KB

And yet… here is the new variable being set to false, despite all conditions being met:

image
image1340×836 113 KB

Am I using AND wrong?

Thank you so much for your help.

2

Hi @Bruno1

Please use the below formula.
{{if((if(2.Var_ClientinP = “false”; 1; 0) * if(2.Var_ClientinR1 = “false”; 1; 0) * if(2.Var_ClientinR2 = “false”; 1; 0) * if(2.Var_ClientinR2 = “false”; 1; 0)) = 1; true; false)}}

image

If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support
Visit us here
Youtube Channel

2 Likes
3

Got it! Thank you so much for your help.