Supprimer un message
etik
Si tu as un numero de compte dans la cellule A1 avec le format correct 000-0000037-37
=IF(MOD(LEFT(SUBSTITUTE(A1,"-",""),10),97)=INT(RIGHT(A1,2)),"OK","PAS OK")
Bon amusement.
=IF(MOD(LEFT(SUBSTITUTE(A1,"-",""),10),97)=INT(RIGHT(A1,2)),"OK","PAS OK")
Bon amusement.