excel中如何文本比较
发布网友
发布时间：2022-04-21 01:06
共2个回答
热心网友
时间：2022-06-17 00:16
使用下列公式之一
=IF(A1="","",MATCH(A1,{"平时","假日","节日"},)+1)
=IF(A1="","",LOOKUP(A1,{"假日","节日","平时"},{3,4,2}))
=IF(A1="","",LOOKUP(A1,{"假日",3;"节日",4;"平时",2}))
=IF(A1="","",VLOOKUP(A1,{"平时",2;"假日",3;"节日",4},2,))
=IF(A1="","",IF(A1="平时",2,IF(A1="假日",3,4)))
=IF(A1="","",HLOOKUP(A1,{"平时","假日","节日";2,3,4},2,))
热心网友
时间：2022-06-17 00:16
=if(A1="平时",2,IF(A1="假日",3,4))
用你的办法也可以，但是得用英文双引号将文本引起来。
