AnsweredAssumed Answered

Ifs and Ands - calculation field basics

Question asked by Lordylordy on Mar 18, 2014
Latest reply on Mar 18, 2014 by philmodjunk


Ifs and Ands - calculation field basics


     Hi all

     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.

     Thanks all!!