In the If/Then Column can you add a "AND" statement?

Ask for Help
1

Is there a way you can create a scenario like this:
IF (A && B) → C
IF (A || B) → C

Or is it restricted to just If A → B? If so, what are some clever solution to try to add the “AND” statement?

Thank you community, I promise one day I’ll stop being a noob and actually contribute aha

2

The most important thing to understand about the if-then-else column is that it will return (short circuit) as soon as a condition passes. So the best approach is what we sometimes refer to as “working backwards”, by eliminating all the false conditions first.

I’m reading that as if (A and B) and C

  • If not C, then false
  • If not A, then false
  • If not B, then false
  • Else true

Or maybe it’s supposed to be if A and B, then C?
In which case:

  • If not A, then false
  • If not B, then false
  • Else C

I’m reading that as If (A or B) and C

  • If not C, then false
  • If A, then true
  • If B, then true

…or should that be If A or B, then C?
If yes, then:

  • If A then C
  • If B then C
3 Likes
3

the idea is: IF A is true AND B is true then output C.

In your example it shows IF A isn’t true AND B isn’t true then C. which is different.

Is there a way to use these short circuits to verify two variables.

What I specifically need is (If string is “X” AND Date is before Y) then C, else FALSE.

4

Just reverse your logic:

  • If string is not X, then false
  • If date is after Y, then false
  • Else C
3 Likes
5

Oh, okay I see what you’re saying. It’s very foreign for me to think that way, when programming it’s usually the other way around.

Thank you Darren

6

Yeah, it takes a bit of getting used to, and seems non-intuitive at first. But as I say, the trick is to reverse your logic and work backwards.

3 Likes
7

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.