Can't seem to get If/Else to compute correctly

I’m trying to get a very simple IF/Else Column to compute correctly, but for some reason I can’t figure out what I’m doing wrong.

I need have two fields A & B

The condition need to be:

If A does not include ‘Unload’ then true
If A does include ‘Unload’ and B is checked then true
If A does include Unload and B is not checked then null

I somehow cannot get this IF/Else to do what I want to do, can someone help?

I think you can just do:

  • If A doesn’t include Unload, then true
  • If B is checked, then true

Your 3rd condition isn’t needed, because you will have eliminated both cases with the first two conditions.

Screen Shot 2022-11-01 at 11.12.52 PM

2 Likes

Ohh god - so easy.
I don’t know why I can’t get my head around these conditionals…

But thank you for saving my sanity

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