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

    multiple selection in if function



      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