How to do in single IF Statement

[#1]

Dear All,

How do we can mention the below condition in a single IF statement like:

=Count( if (Customer <> ('A','B','C','D','E','F','G'),Test1,Test2))

Is there any other alternative ?

[sunil2288]

Hi Kumar ,

You can use set analysis to solve this.

Like

IF(CUSTOMER-={'A','B','C','D'..},COUNT(TEST1),COUNT(TEST2))

Try this....

Thanks

Sunil

[#3]

is there any other option to mention more than one item for a perticular variable like

customer NOT in ('A','B','C',........)

[colinh]

Hi

Try count(if (match(Customer, 'A', 'B', 'C', 'D', 'E', 'F', 'G') = 0, Test1, Test2))

[sunil2288]

Hi Kumar,

Yes for that purpose only Set Analysis came in to existance.

You can do it Like

Count({$<Customer-={'A','B','C',...}>}Test1)

for writing NOT use -=(Minus and equal to combinely)

Regards

Sunil