Determine an RIB key

tobe3 -  
eriiic Posted messages 24581 Registration date   Status Contributeur Last intervention   -
Hello,
I am trying to calculate the RIB key by entering a bank code, a branch code, and an account number using this formula =MOD(97-(89*MOD(A6;97)+15*MOD(B6;97)+3*MOD(C6;97));97) but if I enter an account number that is 11 digits long, the response for the RIB is #NUMBER! Can you help me please?

Configuration: Windows XP / Internet Explorer 6.0

2 réponses

Raymond PENTIER Posted messages 58551 Registration date   Status Contributeur Last intervention   17 475
 
Send your file. Because the formula is apparently correct ...

It's nice, retirement! Especially in the Caribbean ... :-)
☻ Raymond ♂
0