|
最佳回答 |
|
0
|
Z4u3z1Lv6专家互助发布于2022-7-26 09:46
|
IF(D23=="1","已受理",IF(D25=="2","退回修改",IF(D23=="3","关闭工单","unknow"))) |
|
|
|
|
最佳回答 |
|
0
|
lxy2Lv6中级互助发布于2022-7-26 09:45
|
不应该用同一个单元格判断吗if(D23=1,"已受理",if(D25=2,"退回修改",if(D23=3,"关闭工单",""))) |
|
|
|
|
最佳回答 |
|
0
|
snrtuemcLv8专家互助发布于2022-7-26 09:45
|
你这个没法判断，D23=1，D25=2的时候，怎么判断，那个优先？ |
|
|
|
|
最佳回答 |
|
0
|
LSQ000Lv5中级互助发布于2022-7-26 09:47
|
if(D23="1","已受理",if(D23="3","关闭工单",if(D25="2","退回修改",""))) |
|
|
|
|
最佳回答 |
|
0
|
阿北啦啦啦Lv5见习互助发布于2022-7-26 09:48（编辑于 2022-7-26 09:49）
|
|
|
|
|
|
1min目标场景问卷
立即参与
