IF AND 3 Conditions

[JChart]

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!

[CrisYan · Accepted solution]

IF(Field1 = "X" && Field2 = "Y" && and Field3 > Z, "True","False")