14 Replies Latest reply on Oct 25, 2013 12:10 PM by Jonathan Drummey

    Matching String results

    Ben Shirley

      Hi,

       

      I am trying to get a True or False based on Matching String.

       

      Data:

       

      Peg          Hole          Fit

      Round      Square      WONT

      Round      Round       WILL

      Square     Round       WONT

      Triangle    Triangle     WILL

       

      My Current formula is:

       

      IF STR([PEG]) = STR([Hole]) THEN 'WILL'

      ELSE 'WONT'

      END

       

      It tells me i cant use the =

       

      I guess i am doing this utterly wrong, Please help.

       

      Ben