帮我看看这句语句，提示有问题

IF(B1 = "法定节假日" AND B4 <> "邮箱" AND B4 <> "决策平台",IF(C1 >= 18,SQL("linux","select yw from DY_WORKORDER_ROTE where rote = '周内晚值班' and date_id='" + A1 + "'",1,1),SQL("linux","select yw from DY_WORKORDER_ROTE where date_id= '"+ A1 + "' ORDER BY RAND() LIMIT 1",1,1)),"罗淑雁")

FineReport yzmXrTpA3762457 发布于 2022-10-12 09:46

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：3 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共2回答

最佳回答

snrtuemcLv8专家互助
发布于2022-10-12 09:47

IF(B1 = "法定节假日"&&B4 <> "邮箱" && B4 <> "决策平台",IF(C1 >= 18,SQL("linux","select yw from DY_WORKORDER_ROTE where rote = '周内晚值班' and date_id='" + A1 + "'",1,1),SQL("linux","select yw from DY_WORKORDER_ROTE where date_id= '"+ A1 + "' ORDER BY RAND() LIMIT 1",1,1)),"罗淑雁")

RiveryLv5中级互助
发布于2022-10-12 09:49

这样呢，你and用的不对

IF(and(B1 = "法定节假日" , B4 <> "邮箱" , B4 <> "决策平台"),IF(C1 >= 18,SQL("linux","select yw from DY_WORKORDER_ROTE where rote = '周内晚值班' and date_id='" + A1 + "'",1,1),

SQL("linux","select yw from DY_WORKORDER_ROTE where date_id= '"+ A1 + "' ORDER BY RAND() LIMIT 1",1,1)),"罗淑雁")