SharePoint嵌套的IF语句

Question

我一直在做一个计算嵌套的If语句，在SharePoint中不工作，如果有人熟悉SharePoint语法，请帮助我，这里是语句，我不断得到错误。

=如果( or (卖方100%的工作是在办公区进行的，执行管理服务(如数据录入、绘制图纸、监控电话等)？)=“是”，“低风险”，“高风险”，承包商/卖方100%的时间是否由XX员工或XX代表护送进行咨询或观察服务(即看而不摸)？=“是”，“低风险”，“高风险”)

Answer 1

我假设长句只是字段名，因此公式将转换为下面的公式

=IF(OR([A]) = "Yes","Low Risk","High Risk",[B] = "Yes","Low Risk","High Risk")

问题似乎出在or部分，因为OR函数的语法是

OR(logical1，logical2，...)，如果任何参数为真，则返回是；如果所有参数都为假，则返回否。

我假设您希望字段的工作方式为:A或B字段的值为"Yes"，结果为Low Risk，否则将为High Risk。

因此，公式应该类似于=IF(OR([A]= "Yes",[B] = "Yes"),"Low Risk","High Risk")

将实际名称替换为A、B，最终公式为

=IF(OR([Is 100% of the Sellers work being performed in an office area, performing administration services (i.e. data entry, developing drawing, monitoring phone calls etc.)?]= "Yes",[Is the Contractor/Seller 100% of the time escorted by a XX Employee or XX Representative for consulting or observation only services (i.e. looking but not touching)?] = "Yes"),"Low Risk","High Risk")