我已经在网上到处找过了,但似乎没有合适的答案。
=IFS(D2="DgovWIN","D+"(B2-C2)/(B2+C2),D2="RgovWIN","R+"(C2-B2)/(C2+B2),D2="govTIE","0")
=IFS(D2="DgovWIN",D+(B2-C2)/(B2+C2),D2="RgovWIN",R+(C2-B2)/(C2+B2),D2="govTIE","0")
=IFS(D2="DgovWIN","D+(B2-C2)/(B2+C2)",D2="RgovWIN","R+(C2-B2)/(C2+B2)",D2="govTIE","0")
所有这些都不起作用,所以我必须在不同的/新的列中单独制作数字吗?
发布于 2018-08-18 10:19:23
你和几个这样的人很亲近。您只需要将&合并为字符串连接运算符。
=IFS(D2="DgovWIN", "D+"&(B2-C2)/(B2+C2), D2="RgovWIN", "R+"&(C2-B2)/(C2+B2), D2="govTIE", "0")
https://stackoverflow.com/questions/51903234
复制相似问题