或公式中的语句

2020-09-02 15:00发布

点击此处---> 群内免费提供SAP练习系统(在群公告中)加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)我的表中有5个Term字段(Te...

         点击此处--->   EasySAP.com群内免费提供SAP练习系统(在群公告中)

加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)


我的表中有5个Term字段(Term 1,Term 2,Term 3,Term 4,Term 5)。如果它们中的任何一个等于这些值中的任何一个,我希望我的公式返回True。 如果5个条件中的任何一个都不等于这些值中的任何一个,我想返回false:

条款,120个月,72个月或84个月

下面的公式返回True,但从不返回false。 我应该怎么问问题的虚假部分?

如果([[Co-term]," 120个月"," 72个月"," 84个月"]中的{{opportunity.new_termoption1}),则为true,否则[[Co-term "," 120个月"," 72个月"," 84个月"])则为真,否则([" Co-term"," 120个月"," 72个月"," 84个月"中的{{opportunity.new_termoption3} ])则为true,否则为[{Co-term"," 120个月"," 72个月"," 84个月"]中的({opportunity.new_termoption5}),否则为true。 -term"," 120个月"," 72个月"," 84个月"]),则为true,否则为true({[Co-term"," 120个月"," 72个月","中的{opportunity.new_termoption1} 84个月"]),而不是([[Co-term"," 120个月"," 72个月"," 84个月"]]中的{opportunity.new_termoption2} 字词"," 120个月"," 72个月"," 84个月"])和否({[共同条款"," 120个月"," 72个月"," 84个月"]中的{opportunity.new_termoption4} )而不是({[Co-term"," 120个月"," 72个月"," 84个月"]中的{opportunity.new_termoption5}然后为假

5条回答
闻人可可
2020-09-02 16:00

嗨,

尝试以下脚本

如果(在[" Co-term"," 120个月"," 72个月"," 84个月"]中的{opportunity.new_termoption1})则为true
 否则,如果(在[" Co-term"," 120个月"," 72个月"," 84个月"]中的{opportunity.new_termoption2})则为true
 否则,如果(在[" Co-term"," 120个月"," 72个月"," 84个月"]中的{opportunity.new_termoption3})则为true
 否则,如果(在[" Co-term"," 120个月"," 72个月"," 84个月"]中的{opportunity.new_termoption4})则为true
 否则,如果(在[" Co-term"," 120个月"," 72个月"," 84个月"]中的{opportunity.new_termoption5})则为true
 否则为false 

一周热门 更多>