3 Replies Latest reply: Aug 31, 2015 10:30 AM by Dave Melillo RSS

    If Statement Where Field Begins With ...

    Dave Melillo

      I am trying to create an IF statement to classify different field values into normalized ranges. I want to make it so if FIELD starts with B it is categorized as 1 in NewField.

       

      I have created the statement below but it is not working as desired. Any help would be appreciated.

       

      If([FIELD] LIKE 'B%','1',

           If([FIELD] LIKE 'Y%','2',

           If([FIELD] LIKE 'P%','3',

           If([FIELD] LIKE 'F%','4',)))) AS NewField

          

       

      Thank you,

       

      dave