7 Replies Latest reply: Oct 5, 2011 3:22 AM by wsieverink RSS

    multiple selection in if function

      Hello,

       

      I`m using a couple of if functions for setting a selection in a table.

       

      A single if to show just one purchase order state works fine.

      Like this =If([PurchaseItemStatus]='2 CONFIRM',[PurchaseItemStatus])

       

      But I can`t make a selection with more purchase order states combined as a selection.

      for instance I want all order with state '2 CONFIRM' and '3 QC) in one function

       

      any help would be great