关于IF条件 - 我的帆软

关于IF条件

我设置了两个条件属性，如何合并成一个嵌套条件

条件1：IF(S2 != null, round(eval(REPLACE(REPLACE(S2, "N2", N2), "M2", M2)) * 100, 2) + "%", N2)

条件2：IF(AND(replace(M2,"%","")*1 != "100",P2 == '百分数'),round(eval(REPLACE(REPLACE(S2, "N2", replace(N2,"%","")), "M2", replace(M2,"%",""))) * 100, 2) + "%", N2)

FineReport 江东大都督 发布于 2021-7-1 17:32

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：3 F币 + 添加悬赏

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

共1回答

最佳回答

听雨轩Lv6初级互助
发布于2021-7-1 17:41（编辑于 2021-7-1 17:53）

IF(S2 != null, round(eval(REPLACE(REPLACE(S2, "N2", N2), "M2", M2)) * 100, 2) + "%", IF(AND(replace(M2,"%","")*1 != "100",P2 == '百分数'),round(eval(REPLACE(REPLACE(S2, "N2", replace(N2,"%","")), "M2", replace(M2,"%",""))) * 100, 2) + "%", N2))

修改后

IF(len(S2) != 0, round(eval(REPLACE(REPLACE(S2, "N2", N2), "M2", M2)) * 100, 2) + "%", IF(AND(replace(M2,"%","")*1 != "100",P2 == '百分数'),round(eval(REPLACE(REPLACE(S2, "N2", replace(N2,"%","")), "M2", replace(M2,"%",""))) * 100, 2) + "%", N2))