This would be good. I'm sure you know that you can get this logically now with nested IF statements?
Hi Derek,
Is it possible to add AND & OR statements in sequence as an IF step?
I would like to make steps like these:
--> IF (value1=FALSE OR value2=FALSE) THEN abc....
--> IF (value1=FALSE AND value2=TRUE) THEN xyz....
Another improvement would be to make groups (joint AND & OR together), like this:
--> IF ((value1=FALSE AND value2=FALSE) OR (value3=TRUE)) THEN 123....
And would be best if the AND & OR and the groups are unlimited.
Even better if this can also be used as a trigger
Keep it growing!
regards,
Elmar
This would be good. I'm sure you know that you can get this logically now with nested IF statements?
For the moment this doesn't exist, and my advice is the same as Jeff's which is to make use of nested IFs. This should allow you to achieve the AND condition, and to cover OR you should create a second IF outside the first with the relevant condition.
I appreciate this is additional effort, and does have the limitation that you can't combine them in groups as per your second example. I will add this to the backlog, but it will be quite a way off from implementation.
Thanks Derek,
That's the way I use it currently indeed.... I'll continue using nested IF's for the time being.