multiple selection in if function

[#1]

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

[its_anandrjs · Accepted solution]

Hi,

Use Match function and display the data

=If(Match( [PurchaseItemStatus], '2 CONFIRM' ,  '3 QC' ) ,[PurchaseItemStatus] )

It will match multiple items just put like

'2 CONFIRM' , '3 QC' , etc

Let me know

HTH

Rgds

Anand

[swuehl]

I assume you are looking for OR combination of your states, not AND, since a single record state is bound to a single value, right?

Maybe like:

=If(match([PurchaseItemStatus],'2 CONFIRM','3 QC'),[PurchaseItemStatus])

Regards,

Stefan

[#4]

Thanks,

that did the trick

[its_anandrjs]

Hi,

I am also correct would you check it.

Just joking

Rgds

Anand

[#6]

Both are Correct!!

[its_anandrjs]

Hi,

Yes Both are correct and we are glad to help you we try to do as soon as possible.

Rgds

Anand

[#8]

Hi,

one question more regarding this selection.

How do you select , without any status, so status is not filled in

And how do you select, with if filled in (with any data) then select