3 Replies Latest reply on Apr 17, 2018 11:26 AM by Peter Adamo

    Multiple If Contains Statements to Create Filter

    Peter Adamo

      OK so I have multiple Course Descriptions that I need to be able to sort according to specific Guidelines.  This is what I have been able to create so far. I can get it to work singular, but can't do multiple functions...I'm sure I'm missing something fairly simple, but alas I am stuck.  Thoughts?

       

      IF CONTAINS ([Course Description],'(I)') then "Internet Distance Learning"

      or CONTAINS ([Course Description],'(PP)') then "Paper and Pencil Distance Learning"

      or CONTAINS ([Course Description],'(W)') then "Webinar Distance Learning"

      or CONTAINS ([Course Description],'(CR)') then "Classroom"

      else 'MISC'

      END