Ifs and Ands - calculation field basics
I'm failing miserably and an IF and AND calculation field and just can't understand why.
In staement below, can anyone see what I have done wrong with the AND part? The OR parts all working fine, but when I add the AND it delivers the wrong result, sometimes.
If(Process Status = "1" or Process Status = "31" or Process Status = "49" and (Activation Date Check TEXT="Y");"True";"False")
The field Activation Date Check is a calculation field in itself, so I created a text field with the same values in it, but still getting the same result.