on 09-03-2008 9:28 AM
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
Hi there,
Try this one:
IF(((BIC/ZCHBANK = 3.896) OR (BIC/ZCHBANK = 3.202) OR (BIC/ZCHBANK = 3.980)), 'N', 'J' )
Diogo.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
78 | |
9 | |
8 | |
6 | |
6 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.