excel中： 单元格中直接输入1 2 3 4 5数字，自动对应变成“差”“低”“平”“良”“好”

假设数字在a列
在b1单元格输入
=vlookup(a1,{1,"差";2,"低键敏";3,"平";4,"良";5,"好"},2,0）
下脊弯拉稿野枝

再补充一个短的公式
=MID("差低平良好",A1,1)

你想直接对应汉字的话，只能用vba解决了

方法一：A列输入1 2 3 4 5
=VLOOKUP(A1,{1,"差";2,"低";3,"扰散平";4,"良";5,"好"},2,0)公式下拉
方法二：
=LOOKUP(A1,{1,2,3,4,5},{"差","低","平","良","好"})
方法三：
=IF(A1=1,"差",IF(A1=2,"丛伍低",IF(A1=3,"渗李或平",IF(A1=4,"良",IF(A1=5,"好")))))

方法四：
选中需变换的数字，ctrl+f 用替换 1全部替换 成差 。。。

假如数据在A1-A5中，那么可在B1单元格中输入函数：=IF(A1:A5,IF(A1=5,"优",IF(A1=4,"良",IF(A1=3,"中",IF(A1=2,"低"租告,"仔虚差")))))，弊戚明然后向下填充即可。

用if函数,
设要写入的锋扒祥银搏单元格是此饥A1,
=if(a1=1,"差",if(a1=2,"低",if(a1=3,"平",if(a1=4," 良",if(a1=5," 好")))))

=lookup(,0/(a1=row($1:$5)),{"差";"低卖大孝";"平";"中稿良";"好仿拍"})