excel中某个数得一个字

表格中有1-25共25个数字，1-5为一 6-10为二 11-15为三 16-20为四 21-25为五需要在数值后头推算中文数字请问有什么公式谢谢

举报该文章

相关建议 2019-01-09

=TEXT(ROUNDUP(A1/5,),"[DBnum1]")

温馨提示：内容为网友见解，仅供参考

当前网址：https://aolonic.com/aa/kdn451n51wwgann35n.html

第1个回答 2019-01-09

例如你的数据在A1，那么其它单元格中写入以下公式：
=LOOKUP(A1,{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},{"一","一","一","一","一","二","二","二","二","二","三","三","三","三","三","四","四","四","四","四","五","五","五","五","五"})

第2个回答 2019-01-09

=IF(A1>25,"",IF(A1>20,"五",IF(A1>15,"四",IF(A1>10,"三",IF(A1>5,"二",IF(A1>=1,"一",))))))

相似回答

大家正在搜