帆软if怎么再多套一层判断，满足B单元，取AV地市关键字，AV取不到同样满足B，取J列单元格关键字？

帆软if怎改再多套一层判断，满足B单元，取AV地市关键字，AV取不到同样满足B，取J列单元格地市关键字，满足B单元，AV,J都取不到则返回‘本级’，不满足B的条件则就返回‘其他’？

IF(B4="建设有限公司分公司",IF(FIND("南宁",AV4) != 0,"南宁",IF(FIND("桂林",AV4) != 0,"桂林",IF(FIND("柳州",AV4) != 0,"柳州",IF(FIND("玉林",AV4) != 0,"玉林",IF(FIND("百色",AV4) != 0,"百色",IF(FIND("河池",AV4) != 0,"河池",IF(FIND("贵港",AV4) != 0,"贵港",IF(FIND("钦州",AV4) != 0,"钦州",IF(FIND("梧州",AV4) != 0,"梧州",IF(FIND("北海",AV4) != 0,"北海",IF(FIND("崇左",AV4) != 0,"崇左",IF(FIND("来宾",AV4) != 0,"来宾",IF(FIND("贺州",AV4) != 0,"贺州",IF(FIND("防城",AV4) != 0,"防城","本级")))))))))))))),"其他")

FineReport 用户W5SzQ5073 发布于 2023-3-20 12:40 （编辑于 2023-3-20 12:43）

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：3 F币 + 添加悬赏

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

共2回答

最佳回答

Z4u3z1Lv6专家互助
发布于2023-3-20 12:44（编辑于 2023-3-20 14:00）

这么长直接粘贴出来啊

-------------

IF(FIND("南宁",J4) != 0,"南宁",IF(FIND("桂林",J4) != 0,"桂林",IF(FIND("柳州",J4) != 0,"柳州",IF(FIND("玉林",J4) != 0,"玉林",IF(FIND("百色",J4) != 0,"百色",IF(FIND("河池",J4) != 0,"河池",IF(FIND("贵港",J4) != 0,"贵港",IF(FIND("钦州",J4) != 0,"钦州",IF(FIND("梧州",J4) != 0,"梧州",IF(FIND("北海",J4) != 0,"北海",IF(FIND("崇左",J4) != 0,"崇左",IF(FIND("来宾",J4) != 0,"来宾",IF(FIND("贺州",J4) != 0,"贺州",IF(FIND("防城",J4) != 0,"防城","本级"))))))))))))))

)))))))))))))),"其他")