在excel的单元格中,按一定规则选择显示数据?
发布网友
发布时间：2022-04-24 13:12
共2个回答
热心网友
时间：2023-04-27 21:10
=IF(COUNTIF(A1:A10,"超期"),"超期",IF(COUNTIF(A1:A10,"预警"),"预警",IF(COUNTIF(A1:A10,"正常"),"正常","完成")))
热心网友
时间：2023-04-27 21:10
=IF(ISTEXT(VLOOKUP("超期",A:A,1,0)),"超期",IF(ISTEXT(VLOOKUP("预警",A:A,1,0)),"预警",IF(ISTEXT(VLOOKUP("正常",A:A,1,0)),"正常",IF(ISTEXT(VLOOKUP("完成",A:A,1,0)),"完成",0))))
