IF then syntax Question
I know this is simple, but for some reason I can't get the syntax. Example Code: If( [Field A] = true and ([Field B] = "Example1" or [Field C] = "Example2"), "Result A", [Field A] = true and ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendHere is one way. Dispose of the field A question first.
IF(
not [Field A], "", // if field A is false, then result is blank. (null), else we know that Field A is true so carry on ...
[Field B] = "Example1" or [Field C] = "Example2", "Result A",
[Field D] = "Example3" or [Field E] = "Example4", "Result B",
[Field F] = "Example4" or [Field G] = "Example5, "Result C")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
IF(
not [Field A], "", // if field A is false, then result is blank. (null), else we know that Field A is true so carry on ...
[Field B] = "Example1" or [Field C] = "Example2", "Result A",
[Field D] = "Example3" or [Field E] = "Example4", "Result B",
[Field F] = "Example4" or [Field G] = "Example5, "Result C")
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------