大神帮忙看下下面这个IF 函数和switch 函数的问题，谢谢了。

Mamba

If(DataCardValue34.Selected.Value="Harmony ",22,
If(DatacardValue34.Selected.Value="EQS"And DatacardValue35.Selected.Value="HIGH",40,
If(DatacardValue34.Selected.Value="EQS"And DatacardValue35.Selected.Value="LOW",15,
If(DatacardValue34.Selected.Value="TFR"And DatacardValue35.Selected.Value="HIGH",40,
If(DatacardValue34.Selected.Value="TFR"And DatacardValue35.Selected.Value="LOW",15,
If(DatacardValue34.Selected.Value="EQI"And DatacardValue35.Selected.Value="HIGH",45,
If(DatacardValue34.Selected.Value="EQI"And DatacardValue35.Selected.Value="LOW",20,
If(DatacardValue34.Selected.Value="TFO"And DatacardValue35.Selected.Value="HIGH",40,
If(DatacardValue34.Selected.Value="TFO"And DatacardValue35.Selected.Value="HIGH",20
)))))))))

Swith(DataCardValue36.Selected.Value,
"Harmony",22,
"EQS","HIGH",40,
"EQS","LOW",15,
"TFR","HIGH",40,
"TFR","LOW",15,
"EQI","HIGH",45,
"EQI","LOW",20,
"TFO","HIGH",40,
"TFO","LOW",20)

米可爱分享

Mamba 这种判断条件多且情况多的时候，可以试试创建一个临时表或是是数据集合变量，然后根据DatacardValue34.Selected.Value和DatacardValue35.Selected.Value来过滤查询这个集合数据。
创建临时集合
ClearCollect(IFConditions, {Dropdown1Value: "Harmony",Dropdown2Value: "HIGH", Result: 22} , {Dropdown1Value: "Harmony",Dropdown2Value: "LOW", Result: 22} , {Dropdown1Value: "EQS",Dropdown2Value: "HIGH", Result: 40} , {Dropdown1Value: "EQS",Dropdown2Value: "LOW", Result: 15} , {Dropdown1Value: "TFR",Dropdown2Value: "HIGH", Result: 40} , {Dropdown1Value: "TFR",Dropdown2Value: "LOW", Result: 15} , {Dropdown1Value: "EQI",Dropdown2Value: "HIGH", Result: 45} , {Dropdown1Value: "EQI",Dropdown2Value: "LOW", Result: 20} , {Dropdown1Value: "TFO",Dropdown2Value: "HIGH", Result: 40} , {Dropdown1Value: "TFO",Dropdown2Value: "LOW", Result: 20} )
查询结果
LookUp(IFConditions, Dropdown1Value = Dropdown1.Selected.Value && Dropdown2Value = Dropdown2.Selected.Value).Result

王然

If貌似没什么问题，但是最后两个if每件重复的，你可以先写两个条件试试，没问题再加后面的；
Switch那个肯定不对的，应该是一个值对应一个结果，后面两个值对应一个结果肯定不对。

Mamba

简单的试过，没问题，这种判断条件多的，就一直不成功，我回头再试试，老师你们有什么微信或者Qq群大家可以交流的嘛？

Nocturnal-Sec

根据我目前（不多）的经验来看，应该是不建议在有这么多条件来判断的情况下使用If函数，使用Switch是比较方便的。
还有一个问题就是这个Switch函数的逻辑是错的喔，根据上面的if来看，datacardvalue34和35的值是条件，后面的数字也就是datacardvalue36是返回值。那么Switch里面应该先判断card value34和cardvalue35的文本是否满足条件，然后根据这个判断来返回cardvalue36的值，这里简单写一个开头：
Switch(true, DataCardValue34.Selected.Value = "Harmony", 22, And( DataCardValue34.Selected.Value = "EQS", DataCardValue35.Selected.Value = "HIGH"), 40, ...)
判断文本是否符合条件的true or false，然后来返回对应的值。

小菜鸡

你得If 我个人感觉应该这么写

If(DataCardValue34.Selected.Value="Harmony ",22,
(DatacardValue34.Selected.Value="EQS"And DatacardValue35.Selected.Value="HIGH",40,
(DatacardValue34.Selected.Value="EQS"And DatacardValue35.Selected.Value="LOW",15）

你那样判断嵌套得太多了，应该是 if...elseIf 的形式不应该是 if(条件){if(条件)} 的形式