cancel
Showing results for 
Search instead for 
Did you mean: 

multiple selection in formula in update rule

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi there,

Try this one:

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

Diogo.

Former Member
0 Kudos

Hi diogo,

thanks for the quick reply, this works!

Regards,

Jens

Answers (0)