Skip to Content
0
Former Member
Sep 03, 2008 at 08:28 AM

multiple selection in formula in update rule

7 Views

Hi Guru's,

I want to make an exclude selection of two banks (ZCHBANK) of the whole bankselection (ZCHBNKSEL). I made an transformation between these two info objects and now I made a formula IF(BIC/ZCHBANK = (3.896) , 'N', 'J' ). Now I become a list of MD with all banknumbers with the sign J and only for banknumber 3.896 N. This is what I want. But now I want to have more banknumbers which not have to go through. So in other words bank 3.896, 3.202 and 3.980 must be excluded. I am struggling with the formula to exclude more than one banknumber.

I already tried the next formula's but nothing seems to work:

IF(BIC/ZCHBANK = (3.896) OR (3.980) , 'N', 'J' )

IF(BIC/ZCHBANK = (3.896) , (3.980) , 'N', 'J' )

IF(BIC/ZCHBANK = (3.896) , 'N', 'J' )OR IF(BIC/ZCHBANK = (3.980) , 'N', 'J' ).

IF(BIC/ZCHBANK = (3.896) , 'N', 'J' ) IF(BIC/ZCHBANK = (3.980) , 'N', 'J' ).

IF(BIC/ZCHBANK = (3.896) , 'N', 'J' )AND IF(BIC/ZCHBANK = (3.980) , 'N', 'J' ).

IF(BIC/ZCHBANK = (3.896) , 'N', 'J' )& IF(BIC/ZCHBANK = (3.980) , 'N', 'J' ).

Can anybody tell me how I can make a formula so three of banks of whole the bank selectionwill become 'N' in the formula and all the other banks will become 'J' ?

Thanks in advance.

Regards,

Jens