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

    If And Statement in Script



      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!