如何用excel公式判断一串数字末位是奇数还是偶数

2025-04-07 10:14:54
推荐回答(1个)
回答1:

=if(or(and(len(a1)=15,mod(right(a1),2)=0),and(len(a1)=18,mod(mid(a1,17,1),2)=0)),"女","男")