excel 一个公式中包含多个IF条件

nfeuvbwi 于 2023-03-04 发布在其他

关注(0)|答案(1)|浏览(110)

嗨，我是新的Excel从谷歌工作表。我能够做到这一点，在谷歌工作表确定，但有麻烦试图找出Excel。我想把所有这些到一个公式。

=IF(AND(B50="Buy",C50="Call"),FILTER(Sheet1!S6:S31,(Sheet1!U6:U31=E50)*((Sheet1!Q6:Q31=A50)*((Sheet1!R6:R31=C50)))))
    =IF(AND(B50="Buy",C50="Put"),FILTER(Sheet1!S6:S31,(Sheet1!U6:U31=E50)*((Sheet1!Q6:Q31=A50)*((Sheet1!R6:R31=C50)))))
    =IF(AND(B50="Sell",C50="Call"),FILTER(Sheet1!T6:T31,(Sheet1!U6:U31=E50)*((Sheet1!Q6:Q31=A50)*((Sheet1!R6:R31=C50)))))
    =IF(AND(B50="Sell",C50="Put"),FILTER(Sheet1!T6:T31,(Sheet1!U6:U31=E50)*((Sheet1!Q6:Q31=A50)*((Sheet1!R6:R31=C50)))))

Excel帮助窗口将上面的代码更正为下面的片段，但得到“值”错误。每个查询单独工作正常，只是，的和）））的问题，当我把它们放在一起。

=IF(AND(B50="Buy",C50="Call"),FILTER(Sheet1!S6:S31,(Sheet1!U6:U31=E50)*((Sheet1!Q6:Q31=A50)*((Sheet1!R6:R31=C50,
IF(AND(B50="Buy",C50="Put"),FILTER(Sheet1!S6:S31,(Sheet1!U6:U31=E50)*((Sheet1!Q6:Q31=A50)*((Sheet1!R6:R31=C50,
IF(AND(B50="Sell",C50="Call"),FILTER(Sheet1!T6:T31,(Sheet1!U6:U31=E50)*((Sheet1!Q6:Q31=A50)*((Sheet1!R6:R31=C50,
IF(AND(B50="Sell",C50="Put"),FILTER(Sheet1!T6:T31,(Sheet1!U6:U31=E50)*((Sheet1!Q6:Q31=A50)*((Sheet1!R6:R31=C50))))))))))))))))))))

excel

来源：https://stackoverflow.com/questions/75610426/multiple-if-conditions-in-one-formula

1条答案

按热度按时间

anauzrmj1#

你把支架放错了。试试-

=IF(AND(B50="Buy",C50="Call"),FILTER(Sheet1!S6:S31,(Sheet1!U6:U31=E50)*(Sheet1!Q6:Q31=A50)*(Sheet1!R6:R31=C50)),
IF(AND(B50="Buy",C50="Put"),FILTER(Sheet1!S6:S31,(Sheet1!U6:U31=E50)*(Sheet1!Q6:Q31=A50)*(Sheet1!R6:R31=C50)),
IF(AND(B50="Sell",C50="Call"),FILTER(Sheet1!T6:T31,(Sheet1!U6:U31=E50)*(Sheet1!Q6:Q31=A50)*(Sheet1!R6:R31=C50)),
IF(AND(B50="Sell",C50="Put"),FILTER(Sheet1!T6:T31,(Sheet1!U6:U31=E50)*(Sheet1!Q6:Q31=A50)*(Sheet1!R6:R31=C50)),""))))

赞(0）回复(0）举报 2023-03-04

我来回答

excel 一个公式中包含多个IF条件

1条答案

相关问题

热门标签

最新问答