求excel公式!

显示全部楼层 · 2012-7-5 00:41:03

来个笨公式吧=IF(ISNUMBER(FIND("一",A1)),"一级",IF(ISNUMBER(FIND("二",A1)),"二级",IF(ISNUMBER(FIND("三",A1)),"三级",IF(ISNUMBER(FIND("四",A1)),"四级",IF(ISNUMBER(FIND("五",A1)),"五级",IF(ISNUMBER(FIND("六",A1)),"六级",""))))))&IF(ISNUMBER(FIND("七",A1)),"七级",IF(ISNUMBER(FIND("八",A1)),"八级",""))...

千问 · 2012-7-5 00:41:03

如果你单元格中只是中文数字，用这个公式更简单：=lookup(a1,{"八","二","六","七","三","四","五","一";"八级","二级","六级","七级","三级","四级","五级","一级"})...

千问 · 2012-7-5 00:41:03

特别提醒：这是Excel中的一个隐藏函数，在函数向导中是找不到的，可以直接...特别提醒：公式中各参数间，要用英文状态下的逗号“,”隔开。 ...SUM求和......

千问 · 2012-7-5 00:41:03

=TEXT...