Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
First post and I'm hoping you are able to help.
I am trying to build a conditoinal statement using 3 separate fields of data, but I'm not sure how to achieve this.
In a perfect world, I could use IF(AND(Logical1,Logical2),"True","False"). I could then enter each conditional statement for each logical component, but I can only use 2 arguments.
What is the best function to use for 3 logical arguments?
i.e.
if Field1 = "X", and Field2 = "Y", and Field3 > Z, "True","False"
Thanks!
Solved! Go to Solution.
IF(Field1 = "X" && Field2 = "Y" && and Field3 > Z, "True","False")
IF(Field1 = "X" && Field2 = "Y" && and Field3 > Z, "True","False")
User | Count |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |