将汉字大写一至十转为数字1-10匿名 · 更新于 2021/12/31=IF(A1="十",10,IF(A1="九",9,IF(A1="八",8,IF(A1="七",7,IF(A1="六",6,IF(A1="五",5,IF(A1="四",4,IF(A1="三",3,IF(A1="二",2,IF(A1="一",1,0)))))))))) 上一篇Excel年份不变月份累加