4 Replies Latest reply: Dec 8, 2014 1:21 PM by Marco Wedel RSS

    If And Statement in Script

      Hello,

       

      I would like to create the equivalent of an If(And()) statement, as seen in Excel, in the QV script.

       

      I would like an output of '1' if column A = column B = column C, and an output of '0' if this is not true. I imagine the syntax would be something like the following, but haven't got it quite right:

       

           if([A] = [B],if ([B] = [C],1,0)) as [D]

       

      Any thoughts?

       

      Thank you!