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