电脑/网络

小弟遇到excel公式难题,请高手解答下,谢谢!

2018-03-29 05:50:30彼***

小弟遇到excel公式难题,请高手解答下,谢谢!：=IF(OR(A1={"原因不明","涂装","配件","重量"}),"A",IF(OR(A1={"强度","?

=IF(OR(A1={"原因不明","涂装","配件","重量"}),"A",IF(OR(A1={"强度","物性","断裂"}),"B",""))

2018-03-29 07:01:51

不清楚，以前用的很熟练，现在都忘了

2018-03-29 12:01:51

条件A在A列，条件B在B列，要判断的数据在C列，结果在D列。--------------在D1输入：=IF(COUNTIF(A:A,C1),"A",IF(COUNTIF(B:B,C1),"B",))下拉填充D列。

2018-03-29 11:01:51

很赞哦！ (230)