Forum Discussion
SevsBo
Continued Contributor
Continued ContributorNested OR function and separate question on HTML for this forum
Part 1: the formula We are trying to use a nested OR function for a calculated column to say: If UserC is blank, OR if the ID is "", OR the ID is "none", OR the ID is a specific string, then it'...
I'm happy to close this one off. The issue wasn't with the formula but with the logic.... This is the correct way of doing what we wanted to do:
Condition Met = IF(AND (UserC = "" , OR(ID = "", OR(ID = "none", ID = "specific string"))), "Option 1", "Option 2")
In essence UserC has to be blank and then the other criteria come into play. We were using OR on all of them.
SevsBoContinued Contributor
Continued ContributorI'm happy to close this one off. The issue wasn't with the formula but with the logic.... This is the correct way of doing what we wanted to do:
Condition Met = IF(AND (UserC = "" , OR(ID = "", OR(ID = "none", ID = "specific string"))), "Option 1", "Option 2")
In essence UserC has to be blank and then the other criteria come into play. We were using OR on all of them.