3 评论

0 收藏

分享

[产品建议] 请大师看一下这银行卡该如何设置?

=IF(MOD(10-RIGHT(MID({当前数据.农行卡号},1,1)+MID({当前数据.农行卡号},3,1)+MID({当前数据.农行卡号},5,1)+MID({当前数据.农行卡号},7,1)+MID({当前数据.农行卡号},9,1)+MID({当前数据.农行卡号},11,1)+MID({当前数据.农行卡号},13,1)+MID({当前数据.农行卡号},15,1)+MID({当前数据.农行卡号},17,1)+IF(MID({当前数据.农行卡号},2,1)>="5",(MID({当前数据.农行卡号},2,1)-5)*2+1,MID({当前数据.农行卡号},2,1)*2)+IF(MID({当前数据.农行卡号},4,1)>="5",(MID({当前数据.农行卡号},4,1)-5)*2+1,MID({当前数据.农行卡号},4,1)*2)+IF(MID({当前数据.农行卡号},6,1)>="5",(MID({当前数据.农行卡号},6,1)-5)*2+1,MID({当前数据.农行卡号},6,1)*2)+IF(MID({当前数据.农行卡号},8,1)>="5",(MID({当前数据.农行卡号},8,1)-5)*2+1,MID({当前数据.农行卡号},8,1)*2)+IF(MID({当前数据.农行卡号},10,1)>="5",(MID({当前数据.农行卡号},10,1)-5)*2+1,MID({当前数据.农行卡号},10,1)*2)+IF(MID({当前数据.农行卡号},12,1)>="5",(MID({当前数据.农行卡号},12,1)-5)*2+1,MID({当前数据.农行卡号},12,1)*2)+IF(MID({当前数据.农行卡号},14,1)>="5",(MID({当前数据.农行卡号},14,1)-5)*2+1,MID({当前数据.农行卡号},14,1)*2)+IF(MID({当前数据.农行卡号},16,1)>="5",(MID({当前数据.农行卡号},16,1)-5)*2+1,MID({当前数据.农行卡号},16,1)*2)+IF(MID({当前数据.农行卡号},18,1)>="5",(MID({当前数据.农行卡号},18,1)-5)*2+1,MID({当前数据.农行卡号},18,1)*2),1),10)=INT(RIGHT({当前数据.农行卡号},1))0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36[{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"},{"scope":"source_item","table_id":2100000008151526,"field_id":2200000077523463,"field_type":"text"}]

回复

举报 使用道具

全部回复 (3)
查看全部
说下您的验证逻辑,函数能截下图吗,这复制过来的不是原函数

举报 回复 支持 反对 使用道具

微信图片_20181012124033.png

举报 回复 支持 反对 使用道具

请问老师,如何在表中的数据验证 中设置这个银行卡号的验证?

举报 回复 支持 反对 使用道具

清凉莲花世界
注册会员
主题 6
回复 4
粉丝 0
|网站地图
快速回复 返回顶部 返回列表