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