excel表格if函数
发布网友
发布时间：2022-04-22 15:33
共4个回答
热心网友
时间：2023-10-17 15:35
Excel表格IF函数怎么用？这个视频告诉你！
热心网友
时间：2023-10-17 15:35
=VLOOKUP(A1,{"张三","办公室";"李四","办公室";"王五","财务室";"赵六","财务室"},2)
热心网友
时间：2023-10-17 15:35
=IF(OR(A1="张三",A1="李四"),"办公室",IF(OR(A1="王五",A1="赵六"),"财务室",""))
热心网友
时间：2023-10-17 15:36
A2=IF(A1={"张三","李四"},"办公室",IF(A1={"王五","赵六"},"财务室",""))
