excel表格里，同时对3组条件进行判断，输出2种结果，函数该怎么写？

Question

如题所述

Answer 1

把你的公式改一下就，把下图的改成and(A2="轻工时"，b2>80),后面的依次类推就OK啦。

Answer 2

=IF(LOOKUP(A2,{"轻工时","中工时","重工时"},{80,112,144})<B2,"超工时","")
用这个方式，函数看起来要简洁一些。

Answer 3

如果EXCEL2019之后版本
=IF(SWITCH(A2,"轻工时",80,"中工时",112,"重工时",144)<B2,"超工时","")
如果低版本
=IF(LOOKUP(A2,{"轻工时","中工时","重工时"},{80,112,144})<B2,"超工时","")

Answer 4

在C2中输入或复制粘贴下列公式
=IF(OR((A2="轻工时")*(B2>80),(A2="中工时")*(B2>112),(A2="重工时")*(B2>144)),"超工时","")
下拉填充

Answer 5

公式=IF((A2="轻工时")*(B2>80),"超工时",IF((A2="中工时")*(B2>112),"超工时",IF((A2="重工时")*(B2>144),"超工时","")))