If condition

[Anonymous]

I need help with the if condition. The third condition is not being applied where i am using and condition together with if.Can anyone please tell me the issue here?

[HotChilli]

we can't see your data so can't give you an exact answer but you can debug it from your side.

Remove all the other 'if' tests so that you only have the line with the 'and's (put a simple string in the 'else').

Now, copy the line somewhere else (text editor or something - just so you don't lose it)

Remove all the 'and' conditions to make the 'if' conditions work.  Then add 1 'and' condition back in.  See if it breaks. When it works, add another 'and' condition in, then repeat etc. 

[Anonymous]

This is the data i have circled the values as well.

[v-jingzhang · Accepted solution]

Hi @Anonymous 

You could add a pair of parentheses to wrap the third condition in this if statement. This should work.

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.