excel 如果A1等于1,2,3到19的数字,那么B1分别替换为19个对应的汉字

问题描述：

excel 如果A1等于1,2,3到19的数字,那么B1分别替换为19个对应的汉字
并不是要小写数字变大写,这19个对应的汉字在我的自定义序列里边有.希望通过if函数,条件格式等来实现.

1个回答分类：综合 2014-12-02

问题解答：

我来补答

假如这19个数字,在A列.
在B1输入公式：
=LOOKUP(A1,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19},{"甲","乙","丙","丁","戊","已","庚","辛","壬","葵","东","南","西","北","中","春","夏","秋","冬"})
下拉即可.

记得给个采纳哟

展开全文阅读

上一页：请详解【变式3】的过程

下一页：请详解B组提高选做题的过程