假设0-10在A列，A1-A11，在B1输入：
=lookup(a1,{0,1,2,3,4,5,6,7,8,9,10},{1,0,"X",9,8,7,6,5,4,3,2})
换成=LOOKUP(A1,ROW($1:$11)-1,{1,0,"X",9,8,7,6,5,4,3,2})
也可以。
＝LOOKUP(A2,{0,1,2,3,4,5,6,7,8,9,10},{1,0,"X",9,8,7,6,5,4,3,2})
假设数字在A1
=MID("10X98765432",A1+1,1)
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024